События (1000000)

1 000 000 событий в базе

23 полей в событии: 10 измерений + 11 метрик + id и время

55.5 МБ на диске (сжато, 71.6 МБ без сжатия)

≈ 548.4 МБ экспорт в JSON: 1 000 000 строк × 575 Б — в 9.9× больше, чем на диске

События по часам — выделите диапазон мышью, чтобы задать период · MV events_by_hour: прочитано 5 768 строк вместо 1 000 000 · 5.6 мс

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:50:07	speeding	V-008	D-17	R-09	riga	90.5	27.1
2026-07-16 01:49:59	gps_ping	V-001	D-11	R-11	vidzeme	67.4	29.2
2026-07-16 01:49:55	gps_ping	V-018	D-12	R-07	riga	34.7	14.7
2026-07-16 01:49:50	engine_fault	V-039	D-19	R-08	latgale	64.3	12
2026-07-16 01:49:49	trip_end	V-048	D-05	R-01	kurzeme	38.8	22.1
2026-07-16 01:49:40	engine_fault	V-034	D-11	R-07	riga	61.1	31.1
2026-07-16 01:49:39	idle	V-028	D-13	R-11	vidzeme	0	33.2
2026-07-16 01:49:37	gps_ping	V-026	D-21	R-08	latgale	44.2	14.5
2026-07-16 01:49:36	speeding	V-025	D-22	R-10	latgale	62.5	29.3
2026-07-16 01:49:33	trip_end	V-027	D-26	R-11	vidzeme	83.7	28.1
2026-07-16 01:49:32	gps_ping	V-037	D-30	R-12	kurzeme	39	37.3
2026-07-16 01:49:30	gps_ping	V-031	D-11	R-12	kurzeme	81.3	22
2026-07-16 01:49:20	gps_ping	V-013	D-19	R-13	latgale	41.7	12.7
2026-07-16 01:49:20	refuel	V-015	D-07	R-13	latgale	0	27.9
2026-07-16 01:49:19	gps_ping	V-024	D-30	R-04	vidzeme	22.9	14.7
2026-07-16 01:49:12	gps_ping	V-009	D-12	R-06	vidzeme	54.8	32.6
2026-07-16 01:49:11	engine_fault	V-048	D-08	R-12	kurzeme	42	39.6
2026-07-16 01:49:11	engine_fault	V-038	D-01	R-12	kurzeme	55.7	30.4
2026-07-16 01:49:06	trip_end	V-004	D-08	R-14	latgale	59.8	28.4
2026-07-16 01:49:02	gps_ping	V-013	D-16	R-06	vidzeme	77.5	13.1
2026-07-16 01:48:58	trip_end	V-041	D-04	R-08	latgale	32.4	28
2026-07-16 01:48:56	gps_ping	V-043	D-25	R-08	latgale	51.5	20.8
2026-07-16 01:48:55	gps_ping	V-011	D-28	R-03	kurzeme	33.9	14.5
2026-07-16 01:48:53	gps_ping	V-028	D-27	R-07	riga	44.2	30.9
2026-07-16 01:48:51	gps_ping	V-035	D-04	R-15	riga	54.7	31.4
2026-07-16 01:48:50	trip_end	V-042	D-21	R-04	vidzeme	21.9	31.8
2026-07-16 01:48:50	trip_start	V-019	D-03	R-07	riga	62.9	28.6
2026-07-16 01:48:44	engine_fault	V-005	D-10	R-11	vidzeme	47.9	14.7
2026-07-16 01:48:41	idle	V-035	D-15	R-02	kurzeme	0	34.8
2026-07-16 01:48:40	gps_ping	V-030	D-12	R-13	latgale	12.6	15.2
2026-07-16 01:48:38	gps_ping	V-034	D-07	R-11	vidzeme	59.8	27.7
2026-07-16 01:48:37	trip_start	V-017	D-28	R-12	kurzeme	67.5	23.5
2026-07-16 01:48:36	gps_ping	V-025	D-27	R-08	latgale	22.7	31.4
2026-07-16 01:48:36	gps_ping	V-018	D-20	R-01	kurzeme	39.2	15.1
2026-07-16 01:48:34	engine_fault	V-032	D-26	R-12	kurzeme	31.5	17.2
2026-07-16 01:48:34	gps_ping	V-027	D-08	R-03	kurzeme	67.3	25.7
2026-07-16 01:48:33	gps_ping	V-005	D-10	R-05	riga	48.2	15.3
2026-07-16 01:48:32	trip_start	V-038	D-27	R-07	riga	59.5	28
2026-07-16 01:48:20	gps_ping	V-002	D-02	R-11	vidzeme	56.5	32.9
2026-07-16 01:48:18	gps_ping	V-018	D-01	R-12	kurzeme	32.6	13.3
2026-07-16 01:48:18	trip_end	V-040	D-08	R-05	riga	62.1	34.4
2026-07-16 01:48:15	gps_ping	V-015	D-06	R-05	riga	77.8	25.5
2026-07-16 01:48:12	gps_ping	V-048	D-21	R-01	kurzeme	72	28.5
2026-07-16 01:48:12	speeding	V-046	D-09	R-05	riga	77	24.5
2026-07-16 01:48:09	gps_ping	V-014	D-24	R-13	latgale	43.4	29.2
2026-07-16 01:48:07	trip_end	V-048	D-01	R-06	vidzeme	65.4	30.8
2026-07-16 01:48:06	trip_end	V-032	D-18	R-14	latgale	44.9	14.9
2026-07-16 01:48:05	gps_ping	V-046	D-13	R-13	latgale	40.6	33.5
2026-07-16 01:48:04	trip_end	V-012	D-16	R-07	riga	35.9	29.6
2026-07-16 01:48:04	gps_ping	V-050	D-14	R-04	vidzeme	58.1	29.7