События (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 · 43.1 мс

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:51:02	trip_end	V-032	D-08	R-04	vidzeme	26	12.7
2026-07-16 00:51:00	speeding	V-042	D-13	R-06	vidzeme	13.5	33.3
2026-07-16 00:50:59	gps_ping	V-042	D-05	R-13	latgale	63.4	34.3
2026-07-16 00:50:55	trip_start	V-011	D-05	R-09	riga	88.9	11.5
2026-07-16 00:50:51	trip_end	V-004	D-26	R-04	vidzeme	45.4	32
2026-07-16 00:50:50	engine_fault	V-003	D-26	R-03	kurzeme	48.6	26.5
2026-07-16 00:50:50	gps_ping	V-040	D-04	R-12	kurzeme	73	29.9
2026-07-16 00:50:46	gps_ping	V-032	D-22	R-06	vidzeme	24.4	14.1
2026-07-16 00:50:44	gps_ping	V-002	D-27	R-13	latgale	41.4	33.4
2026-07-16 00:50:41	gps_ping	V-022	D-12	R-06	vidzeme	54.4	27.1
2026-07-16 00:50:40	gps_ping	V-024	D-12	R-14	latgale	75.6	13.4
2026-07-16 00:50:40	gps_ping	V-013	D-19	R-08	latgale	74.5	14.5
2026-07-16 00:50:37	idle	V-025	D-16	R-12	kurzeme	0	29.6
2026-07-16 00:50:37	engine_fault	V-047	D-05	R-10	latgale	48.1	13.3
2026-07-16 00:50:35	gps_ping	V-037	D-23	R-01	kurzeme	78.7	35.4
2026-07-16 00:50:34	refuel	V-003	D-02	R-13	latgale	0	34.4
2026-07-16 00:50:32	gps_ping	V-025	D-16	R-01	kurzeme	56.1	27.8
2026-07-16 00:50:30	gps_ping	V-009	D-10	R-09	riga	12.2	40.8
2026-07-16 00:50:27	gps_ping	V-021	D-30	R-02	kurzeme	41	29
2026-07-16 00:50:25	trip_start	V-030	D-01	R-05	riga	29.8	12.9
2026-07-16 00:50:23	trip_start	V-049	D-18	R-08	latgale	81.5	37.7
2026-07-16 00:50:20	speeding	V-029	D-11	R-12	kurzeme	35.9	29.2
2026-07-16 00:50:17	harsh_braking	V-003	D-30	R-01	kurzeme	38.8	25
2026-07-16 00:50:16	gps_ping	V-005	D-10	R-13	latgale	75.2	13.1
2026-07-16 00:50:13	gps_ping	V-021	D-03	R-15	riga	20.7	31.7
2026-07-16 00:50:13	harsh_braking	V-030	D-23	R-07	riga	30.4	16.9
2026-07-16 00:50:11	gps_ping	V-009	D-14	R-05	riga	81.6	31.4
2026-07-16 00:50:10	gps_ping	V-033	D-17	R-12	kurzeme	28.1	31.4
2026-07-16 00:50:07	gps_ping	V-022	D-19	R-01	kurzeme	65.8	27.5
2026-07-16 00:50:03	gps_ping	V-030	D-03	R-03	kurzeme	73.1	7.7
2026-07-16 00:50:01	gps_ping	V-048	D-20	R-11	vidzeme	43	24.4
2026-07-16 00:49:57	gps_ping	V-043	D-14	R-12	kurzeme	75.5	31.1
2026-07-16 00:49:56	gps_ping	V-024	D-04	R-01	kurzeme	27.7	12
2026-07-16 00:49:53	gps_ping	V-011	D-01	R-13	latgale	40.6	18.7
2026-07-16 00:49:53	trip_start	V-037	D-13	R-10	latgale	79.9	34.2
2026-07-16 00:49:53	idle	V-005	D-27	R-06	vidzeme	0	16.8
2026-07-16 00:49:47	gps_ping	V-031	D-08	R-08	latgale	47.1	33.4
2026-07-16 00:49:47	refuel	V-037	D-01	R-11	vidzeme	0	31.9
2026-07-16 00:49:43	gps_ping	V-030	D-17	R-06	vidzeme	85.9	9.1
2026-07-16 00:49:40	gps_ping	V-008	D-22	R-10	latgale	34.8	28.6
2026-07-16 00:49:40	harsh_braking	V-026	D-23	R-15	riga	82.7	10.7
2026-07-16 00:49:35	gps_ping	V-022	D-02	R-11	vidzeme	42.2	27.4
2026-07-16 00:49:30	speeding	V-049	D-13	R-02	kurzeme	91.4	34.9
2026-07-16 00:49:21	trip_end	V-035	D-07	R-08	latgale	23.9	35
2026-07-16 00:49:18	idle	V-031	D-08	R-05	riga	0	33.3
2026-07-16 00:49:13	gps_ping	V-020	D-02	R-09	riga	80.6	27.5
2026-07-16 00:49:10	gps_ping	V-017	D-14	R-01	kurzeme	29.9	37
2026-07-16 00:49:09	harsh_braking	V-040	D-29	R-03	kurzeme	50.2	32.7
2026-07-16 00:49:09	gps_ping	V-001	D-26	R-09	riga	48	26.4
2026-07-16 00:49:06	idle	V-036	D-09	R-04	vidzeme	0	28.7