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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:00:52	refuel	V-003	D-09	R-07	riga	0	22.8
2026-07-16 02:00:47	gps_ping	V-019	D-24	R-15	riga	45.2	21.6
2026-07-16 02:00:42	gps_ping	V-015	D-09	R-11	vidzeme	80.6	24.8
2026-07-16 02:00:41	engine_fault	V-038	D-17	R-08	latgale	71.3	31.3
2026-07-16 02:00:41	trip_start	V-022	D-26	R-02	kurzeme	80	25.9
2026-07-16 02:00:39	gps_ping	V-021	D-25	R-10	latgale	64.2	31.3
2026-07-16 02:00:34	speeding	V-016	D-18	R-04	vidzeme	23.4	36.6
2026-07-16 02:00:28	gps_ping	V-041	D-22	R-14	latgale	77.6	26.1
2026-07-16 02:00:26	trip_start	V-032	D-14	R-15	riga	38	14.9
2026-07-16 02:00:24	gps_ping	V-024	D-18	R-07	riga	48.6	20.3
2026-07-16 02:00:23	gps_ping	V-015	D-23	R-13	latgale	71	28.7
2026-07-16 02:00:14	trip_start	V-011	D-15	R-13	latgale	21.3	16.9
2026-07-16 02:00:13	refuel	V-046	D-15	R-13	latgale	0	27.7
2026-07-16 02:00:03	gps_ping	V-039	D-25	R-15	riga	66.2	13.8
2026-07-16 02:00:01	trip_end	V-038	D-11	R-12	kurzeme	30.7	23.9
2026-07-16 02:00:01	gps_ping	V-041	D-22	R-15	riga	50.7	32.5
2026-07-16 02:00:01	gps_ping	V-048	D-15	R-03	kurzeme	74.7	28.5
2026-07-16 01:59:57	gps_ping	V-003	D-24	R-02	kurzeme	24.2	30
2026-07-16 01:59:54	refuel	V-004	D-27	R-13	latgale	0	20.6
2026-07-16 01:59:50	trip_start	V-010	D-24	R-01	kurzeme	66.1	25.2
2026-07-16 01:59:49	harsh_braking	V-031	D-15	R-12	kurzeme	23.2	30.1
2026-07-16 01:59:45	trip_end	V-041	D-20	R-06	vidzeme	31.1	26.1
2026-07-16 01:59:42	speeding	V-032	D-29	R-15	riga	34.1	13.8
2026-07-16 01:59:41	gps_ping	V-039	D-13	R-05	riga	74.6	15.5
2026-07-16 01:59:38	trip_start	V-034	D-01	R-06	vidzeme	28.5	29.5
2026-07-16 01:59:35	gps_ping	V-044	D-25	R-08	latgale	54.9	35.4
2026-07-16 01:59:31	gps_ping	V-014	D-09	R-09	riga	74.9	35.2
2026-07-16 01:59:25	gps_ping	V-017	D-26	R-05	riga	40.4	31.3
2026-07-16 01:59:21	refuel	V-014	D-15	R-11	vidzeme	0	34.7
2026-07-16 01:59:16	gps_ping	V-028	D-19	R-10	latgale	61.5	35.1
2026-07-16 01:59:14	gps_ping	V-034	D-08	R-09	riga	50.4	26.9
2026-07-16 01:59:13	trip_end	V-015	D-08	R-09	riga	29.6	29.6
2026-07-16 01:59:00	gps_ping	V-015	D-10	R-07	riga	26.3	26.7
2026-07-16 01:58:58	engine_fault	V-026	D-23	R-04	vidzeme	41.8	15.6
2026-07-16 01:58:57	gps_ping	V-026	D-09	R-02	kurzeme	25	13.6
2026-07-16 01:58:55	gps_ping	V-038	D-03	R-05	riga	42.6	22.1
2026-07-16 01:58:51	gps_ping	V-025	D-12	R-07	riga	84.3	26.6
2026-07-16 01:58:51	speeding	V-043	D-06	R-07	riga	7.5	27.4
2026-07-16 01:58:49	idle	V-032	D-14	R-15	riga	0	18.4
2026-07-16 01:58:46	gps_ping	V-003	D-18	R-12	kurzeme	31.6	28.4
2026-07-16 01:58:46	trip_start	V-008	D-08	R-03	kurzeme	40	32.4
2026-07-16 01:58:44	gps_ping	V-032	D-28	R-02	kurzeme	76.6	11
2026-07-16 01:58:44	harsh_braking	V-039	D-10	R-05	riga	56.4	10.4
2026-07-16 01:58:37	refuel	V-017	D-08	R-10	latgale	0	30
2026-07-16 01:58:34	gps_ping	V-006	D-26	R-10	latgale	85.8	27.9
2026-07-16 01:58:34	gps_ping	V-036	D-06	R-11	vidzeme	62.5	31.9
2026-07-16 01:58:34	gps_ping	V-038	D-10	R-01	kurzeme	47	31.3
2026-07-16 01:58:29	idle	V-027	D-09	R-13	latgale	0	25.5
2026-07-16 01:58:29	idle	V-029	D-09	R-03	kurzeme	0	25.7
2026-07-16 01:58:26	speeding	V-011	D-23	R-02	kurzeme	82.9	13