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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:49:06	gps_ping	V-016	D-18	R-11	vidzeme	41.6	30.7
2026-07-16 00:49:06	gps_ping	V-038	D-20	R-03	kurzeme	53.4	24.2
2026-07-16 00:49:02	trip_end	V-035	D-09	R-06	vidzeme	47.1	28.9
2026-07-16 00:49:00	gps_ping	V-019	D-16	R-12	kurzeme	75.8	25.5
2026-07-16 00:48:59	gps_ping	V-045	D-07	R-13	latgale	50	12.2
2026-07-16 00:48:56	engine_fault	V-005	D-15	R-02	kurzeme	66	15
2026-07-16 00:48:54	gps_ping	V-014	D-11	R-15	riga	46.3	40.7
2026-07-16 00:48:51	gps_ping	V-018	D-30	R-05	riga	69.3	13.9
2026-07-16 00:48:51	idle	V-005	D-24	R-11	vidzeme	0	14.7
2026-07-16 00:48:51	gps_ping	V-027	D-29	R-08	latgale	82.2	25.9
2026-07-16 00:48:49	gps_ping	V-044	D-21	R-05	riga	53.6	26.3
2026-07-16 00:48:46	gps_ping	V-027	D-12	R-05	riga	28.7	23.1
2026-07-16 00:48:44	gps_ping	V-019	D-19	R-12	kurzeme	52.2	26.5
2026-07-16 00:48:40	gps_ping	V-014	D-27	R-13	latgale	82.8	35.9
2026-07-16 00:48:38	trip_start	V-033	D-19	R-13	latgale	40.4	28.6
2026-07-16 00:48:38	gps_ping	V-037	D-26	R-05	riga	79.1	29.2
2026-07-16 00:48:30	trip_end	V-050	D-23	R-07	riga	73.1	27.6
2026-07-16 00:48:27	gps_ping	V-050	D-07	R-12	kurzeme	37.9	30.3
2026-07-16 00:48:27	gps_ping	V-021	D-05	R-07	riga	41.7	33.3
2026-07-16 00:48:22	gps_ping	V-033	D-23	R-14	latgale	31.2	25.3
2026-07-16 00:48:20	gps_ping	V-042	D-22	R-01	kurzeme	76	33.5
2026-07-16 00:48:16	trip_end	V-016	D-23	R-06	vidzeme	48.1	33.3
2026-07-16 00:48:16	gps_ping	V-013	D-20	R-07	riga	44	14.1
2026-07-16 00:48:12	gps_ping	V-022	D-03	R-13	latgale	36.2	24.8
2026-07-16 00:48:09	gps_ping	V-030	D-09	R-08	latgale	53.8	13.1
2026-07-16 00:48:01	gps_ping	V-009	D-29	R-09	riga	79.4	28.3
2026-07-16 00:47:59	refuel	V-029	D-13	R-11	vidzeme	0	29.7
2026-07-16 00:47:59	gps_ping	V-023	D-26	R-06	vidzeme	65	24.4
2026-07-16 00:47:58	gps_ping	V-014	D-18	R-14	latgale	42.7	37.8
2026-07-16 00:47:47	gps_ping	V-014	D-28	R-13	latgale	59	32.4
2026-07-16 00:47:45	gps_ping	V-039	D-09	R-03	kurzeme	60.5	13.6
2026-07-16 00:47:45	gps_ping	V-046	D-11	R-01	kurzeme	66.2	32.3
2026-07-16 00:47:40	gps_ping	V-043	D-21	R-11	vidzeme	16.6	32.5
2026-07-16 00:47:37	gps_ping	V-015	D-20	R-01	kurzeme	67.9	35.3
2026-07-16 00:47:36	gps_ping	V-032	D-28	R-01	kurzeme	50	12
2026-07-16 00:47:35	gps_ping	V-043	D-30	R-13	latgale	83.3	29.3
2026-07-16 00:47:34	refuel	V-009	D-17	R-07	riga	0	34.8
2026-07-16 00:47:33	harsh_braking	V-008	D-13	R-05	riga	60.9	27.6
2026-07-16 00:47:30	gps_ping	V-020	D-14	R-06	vidzeme	50.7	25.2
2026-07-16 00:47:29	gps_ping	V-019	D-25	R-01	kurzeme	27.8	24.6
2026-07-16 00:47:26	engine_fault	V-037	D-07	R-13	latgale	34.6	32.8
2026-07-16 00:47:23	gps_ping	V-025	D-07	R-11	vidzeme	62.2	29.5
2026-07-16 00:47:21	gps_ping	V-010	D-20	R-14	latgale	38.9	24.4
2026-07-16 00:47:21	gps_ping	V-004	D-22	R-14	latgale	34	22.1
2026-07-16 00:47:20	speeding	V-039	D-16	R-11	vidzeme	70.5	15
2026-07-16 00:47:19	gps_ping	V-016	D-20	R-04	vidzeme	11.3	28.3
2026-07-16 00:47:18	speeding	V-050	D-13	R-14	latgale	50.7	29
2026-07-16 00:47:13	gps_ping	V-006	D-16	R-01	kurzeme	51.7	25.8
2026-07-16 00:47:11	gps_ping	V-049	D-14	R-02	kurzeme	36.6	35.5
2026-07-16 00:47:08	gps_ping	V-018	D-20	R-02	kurzeme	50.8	14.1