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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:43:08	harsh_braking	V-019	D-08	R-06	vidzeme	31.5	22.7
2026-07-16 01:43:06	gps_ping	V-019	D-07	R-07	riga	71.2	27.4
2026-07-16 01:43:05	harsh_braking	V-043	D-07	R-15	riga	67.8	28.1
2026-07-16 01:43:03	engine_fault	V-043	D-18	R-04	vidzeme	31.4	27.8
2026-07-16 01:43:02	gps_ping	V-012	D-09	R-01	kurzeme	77	27.4
2026-07-16 01:42:58	gps_ping	V-034	D-04	R-13	latgale	49	24.9
2026-07-16 01:42:55	trip_end	V-013	D-19	R-04	vidzeme	37.7	10.1
2026-07-16 01:42:54	gps_ping	V-043	D-24	R-14	latgale	80.7	22.5
2026-07-16 01:42:53	trip_start	V-028	D-16	R-05	riga	90.7	29.2
2026-07-16 01:42:44	speeding	V-047	D-09	R-07	riga	74.1	17.6
2026-07-16 01:42:43	gps_ping	V-030	D-22	R-10	latgale	31.9	16.7
2026-07-16 01:42:39	gps_ping	V-029	D-02	R-13	latgale	40.4	27.9
2026-07-16 01:42:38	gps_ping	V-017	D-09	R-02	kurzeme	35.8	26.5
2026-07-16 01:42:38	idle	V-010	D-17	R-06	vidzeme	0	27.2
2026-07-16 01:42:37	gps_ping	V-008	D-26	R-06	vidzeme	81.4	31.6
2026-07-16 01:42:27	gps_ping	V-014	D-15	R-02	kurzeme	30.6	42.4
2026-07-16 01:42:24	gps_ping	V-024	D-21	R-10	latgale	33.5	13.2
2026-07-16 01:42:22	gps_ping	V-049	D-19	R-08	latgale	60.5	31.1
2026-07-16 01:42:21	gps_ping	V-005	D-27	R-08	latgale	72.6	11.8
2026-07-16 01:42:21	gps_ping	V-007	D-11	R-01	kurzeme	72.7	12.4
2026-07-16 01:42:13	gps_ping	V-002	D-01	R-07	riga	46	31.4
2026-07-16 01:42:11	trip_start	V-015	D-04	R-10	latgale	52.2	30.5
2026-07-16 01:42:11	engine_fault	V-005	D-06	R-11	vidzeme	61.8	14.3
2026-07-16 01:42:09	trip_end	V-013	D-28	R-06	vidzeme	77.8	13.1
2026-07-16 01:42:08	gps_ping	V-047	D-07	R-05	riga	75.1	14.9
2026-07-16 01:42:07	gps_ping	V-018	D-08	R-05	riga	40.9	12.3
2026-07-16 01:42:06	trip_start	V-042	D-23	R-08	latgale	29.9	33
2026-07-16 01:42:03	refuel	V-029	D-19	R-01	kurzeme	0	24.9
2026-07-16 01:41:48	harsh_braking	V-010	D-24	R-12	kurzeme	32.8	22.3
2026-07-16 01:41:47	trip_start	V-027	D-04	R-11	vidzeme	75	28.5
2026-07-16 01:41:43	speeding	V-020	D-24	R-02	kurzeme	72.5	26
2026-07-16 01:41:37	gps_ping	V-001	D-02	R-15	riga	67.4	33.2
2026-07-16 01:41:35	trip_end	V-047	D-13	R-08	latgale	56.6	12
2026-07-16 01:41:34	engine_fault	V-031	D-16	R-14	latgale	35	28.8
2026-07-16 01:41:32	gps_ping	V-030	D-10	R-03	kurzeme	79.2	11.4
2026-07-16 01:41:32	harsh_braking	V-011	D-02	R-12	kurzeme	62.8	11.5
2026-07-16 01:41:28	gps_ping	V-024	D-14	R-08	latgale	34.2	12.1
2026-07-16 01:41:28	trip_start	V-019	D-10	R-10	latgale	49.7	28.6
2026-07-16 01:41:25	trip_start	V-029	D-08	R-04	vidzeme	68.8	30
2026-07-16 01:41:20	gps_ping	V-031	D-08	R-12	kurzeme	94.7	24.4
2026-07-16 01:41:12	gps_ping	V-030	D-22	R-01	kurzeme	85.1	13.2
2026-07-16 01:41:12	gps_ping	V-037	D-12	R-12	kurzeme	64.6	31.4
2026-07-16 01:41:06	gps_ping	V-036	D-28	R-05	riga	59.8	29.5
2026-07-16 01:41:01	gps_ping	V-035	D-29	R-08	latgale	59.8	26.2
2026-07-16 01:41:00	gps_ping	V-003	D-24	R-13	latgale	66.5	30.9
2026-07-16 01:40:59	gps_ping	V-043	D-15	R-08	latgale	64.2	30.1
2026-07-16 01:40:58	gps_ping	V-048	D-16	R-01	kurzeme	59.7	29.1
2026-07-16 01:40:57	gps_ping	V-033	D-06	R-05	riga	61.8	28.6
2026-07-16 01:40:56	idle	V-047	D-24	R-12	kurzeme	0	13.2
2026-07-16 01:40:55	gps_ping	V-008	D-25	R-05	riga	58.4	26