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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:27:55	gps_ping	V-046	D-02	R-04	vidzeme	51.8	27.9
2026-07-16 02:27:51	gps_ping	V-025	D-19	R-06	vidzeme	25	25.3
2026-07-16 02:27:46	gps_ping	V-007	D-08	R-03	kurzeme	81.6	15.8
2026-07-16 02:27:45	gps_ping	V-019	D-25	R-08	latgale	35.3	28.8
2026-07-16 02:27:44	refuel	V-035	D-01	R-12	kurzeme	0	33.9
2026-07-16 02:27:38	trip_end	V-048	D-08	R-09	riga	60.8	30.4
2026-07-16 02:27:36	speeding	V-038	D-04	R-10	latgale	52.8	22.1
2026-07-16 02:27:36	trip_end	V-021	D-25	R-08	latgale	43.1	31.5
2026-07-16 02:27:34	gps_ping	V-040	D-21	R-11	vidzeme	46.3	34.2
2026-07-16 02:27:33	gps_ping	V-047	D-16	R-05	riga	63.5	15.3
2026-07-16 02:27:30	gps_ping	V-044	D-10	R-03	kurzeme	36.1	28.2
2026-07-16 02:27:27	gps_ping	V-034	D-25	R-07	riga	28.4	25.4
2026-07-16 02:27:26	trip_start	V-019	D-19	R-06	vidzeme	22	29.2
2026-07-16 02:27:26	trip_start	V-025	D-09	R-14	latgale	58.6	28
2026-07-16 02:27:20	gps_ping	V-015	D-27	R-06	vidzeme	64.8	28.8
2026-07-16 02:27:20	trip_start	V-043	D-13	R-15	riga	77.7	33
2026-07-16 02:27:18	gps_ping	V-043	D-07	R-07	riga	46.6	31.7
2026-07-16 02:27:08	idle	V-033	D-10	R-11	vidzeme	0	28.5
2026-07-16 02:27:07	gps_ping	V-018	D-28	R-07	riga	84.9	17.2
2026-07-16 02:27:05	gps_ping	V-029	D-30	R-07	riga	88.1	21.2
2026-07-16 02:27:04	trip_start	V-010	D-21	R-12	kurzeme	27.2	27
2026-07-16 02:27:03	trip_end	V-032	D-01	R-05	riga	45.6	12.6
2026-07-16 02:27:00	gps_ping	V-029	D-21	R-06	vidzeme	54.3	30.6
2026-07-16 02:26:57	gps_ping	V-034	D-19	R-10	latgale	44.5	23.5
2026-07-16 02:26:57	gps_ping	V-019	D-06	R-08	latgale	26.5	29.2
2026-07-16 02:26:56	trip_start	V-015	D-23	R-15	riga	40.6	31.8
2026-07-16 02:26:56	trip_start	V-006	D-30	R-08	latgale	64.9	31.4
2026-07-16 02:26:50	trip_end	V-014	D-10	R-13	latgale	46.7	33.8
2026-07-16 02:26:50	trip_start	V-037	D-14	R-12	kurzeme	28.6	31.4
2026-07-16 02:26:41	gps_ping	V-042	D-08	R-02	kurzeme	47.7	30.5
2026-07-16 02:26:39	trip_start	V-049	D-03	R-08	latgale	33.2	31.6
2026-07-16 02:26:37	gps_ping	V-028	D-01	R-09	riga	52.2	33.3
2026-07-16 02:26:26	gps_ping	V-043	D-01	R-02	kurzeme	40.4	28.7
2026-07-16 02:26:25	gps_ping	V-012	D-02	R-11	vidzeme	31.4	30.2
2026-07-16 02:26:22	gps_ping	V-032	D-26	R-13	latgale	53.2	15.2
2026-07-16 02:26:21	gps_ping	V-007	D-21	R-13	latgale	54.8	15.1
2026-07-16 02:26:17	trip_start	V-012	D-16	R-05	riga	37.7	26.8
2026-07-16 02:26:14	gps_ping	V-013	D-06	R-06	vidzeme	75.5	14.9
2026-07-16 02:26:12	gps_ping	V-050	D-09	R-01	kurzeme	57	25.2
2026-07-16 02:26:08	gps_ping	V-007	D-18	R-09	riga	98.9	15.5
2026-07-16 02:26:08	gps_ping	V-044	D-12	R-12	kurzeme	62.8	28.3
2026-07-16 02:26:07	gps_ping	V-011	D-20	R-08	latgale	42.9	16.6
2026-07-16 02:26:05	harsh_braking	V-040	D-02	R-03	kurzeme	78.4	34.4
2026-07-16 02:26:05	gps_ping	V-022	D-29	R-11	vidzeme	34.9	22.9
2026-07-16 02:26:01	gps_ping	V-045	D-18	R-08	latgale	42.3	11.2
2026-07-16 02:26:00	gps_ping	V-045	D-29	R-04	vidzeme	38.7	15.3
2026-07-16 02:25:56	trip_end	V-050	D-20	R-14	latgale	78.4	24.3
2026-07-16 02:25:54	gps_ping	V-008	D-07	R-07	riga	55.2	30.7
2026-07-16 02:25:52	gps_ping	V-006	D-02	R-06	vidzeme	69.9	30.7
2026-07-16 02:25:50	idle	V-007	D-30	R-12	kurzeme	0	16.2