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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:35:33	gps_ping	V-002	D-06	R-14	latgale	61.3	35.1
2026-07-16 00:35:31	gps_ping	V-028	D-11	R-11	vidzeme	34.1	28.8
2026-07-16 00:35:25	gps_ping	V-002	D-09	R-09	riga	54.4	37.8
2026-07-16 00:35:23	gps_ping	V-044	D-25	R-10	latgale	65.9	42.3
2026-07-16 00:35:22	harsh_braking	V-018	D-03	R-05	riga	37.3	19.9
2026-07-16 00:35:20	trip_start	V-044	D-17	R-10	latgale	30.4	32.8
2026-07-16 00:35:18	gps_ping	V-042	D-24	R-02	kurzeme	23.8	36
2026-07-16 00:35:11	gps_ping	V-048	D-24	R-04	vidzeme	37.6	27.4
2026-07-16 00:35:02	gps_ping	V-035	D-28	R-04	vidzeme	51.4	30
2026-07-16 00:35:01	speeding	V-048	D-14	R-11	vidzeme	60.3	23.6
2026-07-16 00:34:57	gps_ping	V-013	D-27	R-13	latgale	52.5	15.8
2026-07-16 00:34:49	gps_ping	V-027	D-19	R-03	kurzeme	79.5	29.3
2026-07-16 00:34:49	gps_ping	V-041	D-26	R-01	kurzeme	85.1	35.2
2026-07-16 00:34:47	trip_start	V-014	D-09	R-13	latgale	49.1	29
2026-07-16 00:34:45	gps_ping	V-022	D-01	R-13	latgale	35.2	26
2026-07-16 00:34:42	gps_ping	V-025	D-20	R-01	kurzeme	61.4	32.2
2026-07-16 00:34:33	gps_ping	V-015	D-09	R-04	vidzeme	40.8	28
2026-07-16 00:34:32	engine_fault	V-044	D-24	R-11	vidzeme	35.1	28.6
2026-07-16 00:34:27	gps_ping	V-034	D-10	R-06	vidzeme	77.9	31.1
2026-07-16 00:34:24	gps_ping	V-019	D-05	R-14	latgale	37	28.8
2026-07-16 00:34:23	gps_ping	V-032	D-12	R-05	riga	46.7	13.8
2026-07-16 00:34:18	speeding	V-030	D-13	R-14	latgale	71.7	19.6
2026-07-16 00:34:14	engine_fault	V-040	D-09	R-13	latgale	46.6	33.8
2026-07-16 00:34:08	trip_start	V-020	D-16	R-13	latgale	78.2	29.3
2026-07-16 00:34:07	gps_ping	V-026	D-29	R-14	latgale	45.5	16
2026-07-16 00:34:05	gps_ping	V-031	D-16	R-07	riga	41.6	24.8
2026-07-16 00:34:03	engine_fault	V-030	D-15	R-13	latgale	56.7	14.2
2026-07-16 00:34:00	engine_fault	V-009	D-04	R-06	vidzeme	82.9	32.2
2026-07-16 00:34:00	gps_ping	V-037	D-04	R-09	riga	31.2	32.1
2026-07-16 00:33:56	idle	V-048	D-11	R-02	kurzeme	0	26.2
2026-07-16 00:33:56	refuel	V-010	D-10	R-04	vidzeme	0	29.5
2026-07-16 00:33:52	gps_ping	V-005	D-08	R-07	riga	89.2	14.9
2026-07-16 00:33:49	gps_ping	V-028	D-07	R-10	latgale	52.5	37.3
2026-07-16 00:33:49	trip_start	V-044	D-23	R-13	latgale	40.6	28.7
2026-07-16 00:33:47	gps_ping	V-008	D-18	R-15	riga	89.8	28.7
2026-07-16 00:33:44	trip_start	V-019	D-24	R-12	kurzeme	9.5	30
2026-07-16 00:33:39	gps_ping	V-029	D-05	R-04	vidzeme	32.4	31.6
2026-07-16 00:33:38	trip_end	V-011	D-04	R-15	riga	26.2	13.5
2026-07-16 00:33:37	gps_ping	V-033	D-19	R-02	kurzeme	83.2	27.1
2026-07-16 00:33:36	gps_ping	V-003	D-27	R-10	latgale	75.6	27.8
2026-07-16 00:33:35	refuel	V-027	D-16	R-03	kurzeme	0	23.7
2026-07-16 00:33:33	trip_start	V-007	D-18	R-02	kurzeme	39.9	17.1
2026-07-16 00:33:32	trip_end	V-042	D-14	R-06	vidzeme	42.5	34
2026-07-16 00:33:32	gps_ping	V-004	D-25	R-02	kurzeme	35.5	27
2026-07-16 00:33:31	refuel	V-017	D-21	R-03	kurzeme	0	29.1
2026-07-16 00:33:28	trip_start	V-037	D-28	R-07	riga	66.7	30.1
2026-07-16 00:33:18	gps_ping	V-018	D-24	R-04	vidzeme	36	12.2
2026-07-16 00:33:16	refuel	V-046	D-04	R-05	riga	0	28.9
2026-07-16 00:33:15	gps_ping	V-012	D-21	R-11	vidzeme	46	24.1
2026-07-16 00:33:14	gps_ping	V-028	D-26	R-03	kurzeme	38.5	41.1