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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:17:46	gps_ping	V-031	D-26	R-09	riga	40.7	26
2026-07-16 02:17:44	trip_start	V-044	D-04	R-01	kurzeme	31.2	30.3
2026-07-16 02:17:41	gps_ping	V-011	D-27	R-02	kurzeme	87.9	19.6
2026-07-16 02:17:40	harsh_braking	V-036	D-08	R-15	riga	17	29.2
2026-07-16 02:17:39	harsh_braking	V-026	D-20	R-05	riga	79.5	12.9
2026-07-16 02:17:39	gps_ping	V-018	D-26	R-02	kurzeme	32.7	15.7
2026-07-16 02:17:37	trip_start	V-041	D-10	R-10	latgale	41.4	27.3
2026-07-16 02:17:36	gps_ping	V-009	D-17	R-03	kurzeme	47.3	33.7
2026-07-16 02:17:36	idle	V-007	D-28	R-14	latgale	0	14.9
2026-07-16 02:17:31	trip_start	V-013	D-17	R-02	kurzeme	45.5	12.5
2026-07-16 02:17:30	gps_ping	V-043	D-07	R-05	riga	56.9	33.8
2026-07-16 02:17:30	gps_ping	V-037	D-11	R-07	riga	48.4	29.8
2026-07-16 02:17:29	gps_ping	V-007	D-10	R-01	kurzeme	76	11.5
2026-07-16 02:17:26	gps_ping	V-034	D-04	R-08	latgale	37.5	27.4
2026-07-16 02:17:21	gps_ping	V-001	D-10	R-07	riga	63.9	30.5
2026-07-16 02:17:21	gps_ping	V-025	D-05	R-14	latgale	37.8	25.6
2026-07-16 02:17:12	gps_ping	V-011	D-24	R-03	kurzeme	28	14.5
2026-07-16 02:17:12	idle	V-034	D-18	R-05	riga	0	25.9
2026-07-16 02:17:07	gps_ping	V-038	D-18	R-05	riga	38.9	29.8
2026-07-16 02:17:07	gps_ping	V-026	D-02	R-02	kurzeme	34.4	11.7
2026-07-16 02:17:05	gps_ping	V-014	D-14	R-15	riga	66.2	33.7
2026-07-16 02:16:58	gps_ping	V-040	D-13	R-05	riga	29.5	33.7
2026-07-16 02:16:55	gps_ping	V-002	D-22	R-02	kurzeme	33.3	30.5
2026-07-16 02:16:53	gps_ping	V-033	D-02	R-06	vidzeme	76.2	30.2
2026-07-16 02:16:53	trip_start	V-047	D-12	R-14	latgale	88.8	14.6
2026-07-16 02:16:51	gps_ping	V-020	D-23	R-10	latgale	79.2	30.2
2026-07-16 02:16:50	refuel	V-012	D-07	R-10	latgale	0	29.4
2026-07-16 02:16:49	refuel	V-026	D-08	R-08	latgale	0	16.9
2026-07-16 02:16:47	gps_ping	V-026	D-30	R-06	vidzeme	42	15.1
2026-07-16 02:16:44	refuel	V-023	D-22	R-09	riga	0	32.5
2026-07-16 02:16:36	gps_ping	V-028	D-17	R-06	vidzeme	80	34
2026-07-16 02:16:34	trip_start	V-005	D-11	R-08	latgale	82.1	16.1
2026-07-16 02:16:33	gps_ping	V-022	D-16	R-13	latgale	44.8	28.4
2026-07-16 02:16:30	gps_ping	V-003	D-27	R-01	kurzeme	38	28.5
2026-07-16 02:16:25	gps_ping	V-037	D-29	R-03	kurzeme	44.1	32.1
2026-07-16 02:16:12	gps_ping	V-013	D-26	R-12	kurzeme	17.7	13
2026-07-16 02:16:11	trip_start	V-008	D-10	R-07	riga	34.4	27.3
2026-07-16 02:16:04	engine_fault	V-049	D-28	R-10	latgale	60.6	43.5
2026-07-16 02:16:02	gps_ping	V-037	D-25	R-08	latgale	35.9	30.3
2026-07-16 02:16:02	trip_end	V-001	D-02	R-05	riga	66	30.8
2026-07-16 02:16:00	trip_start	V-034	D-26	R-03	kurzeme	36.8	29.3
2026-07-16 02:15:59	gps_ping	V-020	D-19	R-14	latgale	67.4	32.2
2026-07-16 02:15:57	trip_start	V-007	D-08	R-03	kurzeme	88.6	16.6
2026-07-16 02:15:57	gps_ping	V-045	D-27	R-11	vidzeme	64.9	14.1
2026-07-16 02:15:55	gps_ping	V-028	D-14	R-05	riga	34.1	30.7
2026-07-16 02:15:54	gps_ping	V-046	D-09	R-10	latgale	68.5	23.6
2026-07-16 02:15:54	gps_ping	V-001	D-22	R-04	vidzeme	37.4	29
2026-07-16 02:15:51	gps_ping	V-017	D-10	R-15	riga	65.2	27
2026-07-16 02:15:50	gps_ping	V-035	D-29	R-08	latgale	52.1	34.2
2026-07-16 02:15:50	speeding	V-007	D-13	R-10	latgale	51.2	11.5