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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:55:35	trip_end	V-044	D-09	R-04	vidzeme	40.6	24
2026-07-16 00:55:31	gps_ping	V-022	D-13	R-06	vidzeme	34.9	31
2026-07-16 00:55:23	trip_start	V-010	D-08	R-03	kurzeme	66.9	28.1
2026-07-16 00:55:22	harsh_braking	V-034	D-13	R-15	riga	46.1	29.5
2026-07-16 00:55:22	trip_end	V-028	D-03	R-10	latgale	48.2	37.2
2026-07-16 00:55:17	trip_start	V-048	D-08	R-05	riga	39.3	25.5
2026-07-16 00:55:17	gps_ping	V-011	D-11	R-13	latgale	80.8	12.3
2026-07-16 00:55:17	trip_end	V-009	D-22	R-10	latgale	29.5	36.4
2026-07-16 00:55:15	gps_ping	V-003	D-06	R-05	riga	60.4	31.4
2026-07-16 00:55:10	trip_start	V-036	D-13	R-11	vidzeme	81.6	33.2
2026-07-16 00:55:10	gps_ping	V-027	D-19	R-09	riga	57.1	33.4
2026-07-16 00:55:06	idle	V-004	D-19	R-13	latgale	0	26.2
2026-07-16 00:55:05	gps_ping	V-019	D-17	R-13	latgale	46.4	27
2026-07-16 00:55:01	gps_ping	V-009	D-20	R-09	riga	33.8	34.8
2026-07-16 00:55:01	gps_ping	V-050	D-24	R-03	kurzeme	45.4	26.8
2026-07-16 00:54:59	idle	V-020	D-10	R-12	kurzeme	0	25.2
2026-07-16 00:54:59	gps_ping	V-038	D-08	R-14	latgale	75.8	31.7
2026-07-16 00:54:48	trip_start	V-029	D-17	R-07	riga	34.9	31.8
2026-07-16 00:54:47	trip_end	V-018	D-03	R-02	kurzeme	35.5	15.1
2026-07-16 00:54:45	trip_start	V-042	D-12	R-14	latgale	36.5	31.7
2026-07-16 00:54:43	gps_ping	V-017	D-22	R-08	latgale	32.1	25.7
2026-07-16 00:54:41	trip_end	V-028	D-18	R-09	riga	48.3	33.5
2026-07-16 00:54:41	gps_ping	V-014	D-15	R-03	kurzeme	30.3	29.6
2026-07-16 00:54:38	gps_ping	V-008	D-13	R-09	riga	44.2	26.5
2026-07-16 00:54:33	idle	V-030	D-23	R-03	kurzeme	0	13
2026-07-16 00:54:32	trip_end	V-001	D-16	R-08	latgale	55.6	22.6
2026-07-16 00:54:29	trip_end	V-035	D-01	R-01	kurzeme	92.9	32.2
2026-07-16 00:54:25	gps_ping	V-004	D-11	R-08	latgale	23.6	38
2026-07-16 00:54:20	speeding	V-042	D-21	R-10	latgale	74.1	31.5
2026-07-16 00:54:18	gps_ping	V-048	D-19	R-01	kurzeme	72.9	31.3
2026-07-16 00:54:16	trip_start	V-008	D-12	R-06	vidzeme	28.4	26.8
2026-07-16 00:54:12	gps_ping	V-018	D-25	R-02	kurzeme	70.7	13.8
2026-07-16 00:54:12	gps_ping	V-050	D-17	R-02	kurzeme	54	26.6
2026-07-16 00:54:08	gps_ping	V-003	D-15	R-07	riga	92.6	33
2026-07-16 00:54:05	gps_ping	V-028	D-30	R-07	riga	58.3	33.3
2026-07-16 00:54:04	harsh_braking	V-012	D-01	R-11	vidzeme	49.8	29.8
2026-07-16 00:54:00	refuel	V-021	D-05	R-04	vidzeme	0	30.7
2026-07-16 00:54:00	idle	V-043	D-14	R-10	latgale	0	30.6
2026-07-16 00:53:54	gps_ping	V-030	D-01	R-04	vidzeme	34.4	16.9
2026-07-16 00:53:53	gps_ping	V-046	D-18	R-01	kurzeme	74.7	29.8
2026-07-16 00:53:53	gps_ping	V-034	D-08	R-15	riga	46.5	32.1
2026-07-16 00:53:51	gps_ping	V-011	D-01	R-05	riga	35.3	13.8
2026-07-16 00:53:47	gps_ping	V-044	D-10	R-12	kurzeme	40.5	29.5
2026-07-16 00:53:46	gps_ping	V-041	D-12	R-12	kurzeme	29.2	31.2
2026-07-16 00:53:43	refuel	V-013	D-02	R-10	latgale	0	14.4
2026-07-16 00:53:42	trip_end	V-022	D-07	R-11	vidzeme	37.8	24
2026-07-16 00:53:37	gps_ping	V-014	D-12	R-04	vidzeme	42.7	28.1
2026-07-16 00:53:37	gps_ping	V-017	D-21	R-08	latgale	78.2	28
2026-07-16 00:53:34	gps_ping	V-001	D-19	R-15	riga	36.5	25.6
2026-07-16 00:53:33	gps_ping	V-021	D-26	R-04	vidzeme	52.7	34.8