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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:09:25	trip_end	V-004	D-05	R-03	kurzeme	54.2	29.1
2026-07-16 01:09:21	gps_ping	V-025	D-13	R-07	riga	74.8	28.3
2026-07-16 01:09:18	engine_fault	V-041	D-28	R-01	kurzeme	87.4	27.5
2026-07-16 01:09:14	gps_ping	V-011	D-11	R-03	kurzeme	70.5	12
2026-07-16 01:09:12	gps_ping	V-018	D-24	R-14	latgale	46.1	15.6
2026-07-16 01:09:05	gps_ping	V-041	D-14	R-08	latgale	80.9	31.9
2026-07-16 01:09:03	engine_fault	V-039	D-16	R-02	kurzeme	34.5	15.2
2026-07-16 01:09:03	gps_ping	V-030	D-07	R-03	kurzeme	62.4	14.4
2026-07-16 01:09:01	idle	V-021	D-07	R-15	riga	0	34.5
2026-07-16 01:08:52	gps_ping	V-029	D-27	R-04	vidzeme	21.7	22.9
2026-07-16 01:08:47	engine_fault	V-045	D-25	R-04	vidzeme	41.9	11.8
2026-07-16 01:08:46	harsh_braking	V-045	D-07	R-09	riga	77.1	9.6
2026-07-16 01:08:41	idle	V-003	D-06	R-02	kurzeme	0	26
2026-07-16 01:08:40	engine_fault	V-028	D-17	R-11	vidzeme	31.1	36.6
2026-07-16 01:08:37	gps_ping	V-039	D-25	R-13	latgale	50.8	16.6
2026-07-16 01:08:35	gps_ping	V-050	D-12	R-07	riga	62.8	22.3
2026-07-16 01:08:34	gps_ping	V-011	D-17	R-03	kurzeme	29.7	11.7
2026-07-16 01:08:29	gps_ping	V-033	D-23	R-04	vidzeme	44.1	22.6
2026-07-16 01:08:28	trip_end	V-037	D-16	R-11	vidzeme	89.8	31.1
2026-07-16 01:08:25	gps_ping	V-046	D-28	R-12	kurzeme	77.4	27.9
2026-07-16 01:08:22	engine_fault	V-050	D-30	R-10	latgale	77.8	25
2026-07-16 01:08:21	gps_ping	V-012	D-19	R-01	kurzeme	61.3	30.6
2026-07-16 01:08:19	gps_ping	V-006	D-15	R-08	latgale	53.3	29.9
2026-07-16 01:08:15	refuel	V-041	D-13	R-06	vidzeme	0	20.4
2026-07-16 01:08:15	speeding	V-034	D-23	R-02	kurzeme	51.5	29.3
2026-07-16 01:08:09	gps_ping	V-032	D-10	R-05	riga	28.9	16.7
2026-07-16 01:08:08	gps_ping	V-002	D-17	R-12	kurzeme	41.3	30.9
2026-07-16 01:08:07	trip_end	V-017	D-08	R-06	vidzeme	28	31.2
2026-07-16 01:07:58	gps_ping	V-026	D-03	R-04	vidzeme	41.9	9.8
2026-07-16 01:07:58	harsh_braking	V-037	D-11	R-14	latgale	78.6	42.1
2026-07-16 01:07:47	engine_fault	V-004	D-17	R-13	latgale	23.7	31.6
2026-07-16 01:07:44	trip_end	V-033	D-10	R-08	latgale	34.9	32.6
2026-07-16 01:07:43	gps_ping	V-026	D-01	R-03	kurzeme	72.6	16
2026-07-16 01:07:39	refuel	V-003	D-04	R-14	latgale	0	31.1
2026-07-16 01:07:38	gps_ping	V-037	D-13	R-08	latgale	39	34
2026-07-16 01:07:34	harsh_braking	V-012	D-14	R-02	kurzeme	66.9	27.2
2026-07-16 01:07:32	gps_ping	V-001	D-08	R-02	kurzeme	50.7	21.3
2026-07-16 01:07:31	gps_ping	V-029	D-09	R-07	riga	78.9	24.4
2026-07-16 01:07:27	trip_end	V-034	D-02	R-11	vidzeme	72.3	29.5
2026-07-16 01:07:19	gps_ping	V-002	D-02	R-05	riga	82.9	30.5
2026-07-16 01:07:19	trip_start	V-031	D-12	R-02	kurzeme	66.4	29.5
2026-07-16 01:07:15	harsh_braking	V-029	D-05	R-08	latgale	44.2	36.1
2026-07-16 01:07:09	trip_end	V-046	D-08	R-10	latgale	65.7	31.4
2026-07-16 01:07:08	gps_ping	V-015	D-21	R-13	latgale	34.8	31.3
2026-07-16 01:07:05	gps_ping	V-037	D-25	R-09	riga	24.4	34.3
2026-07-16 01:07:01	speeding	V-041	D-06	R-03	kurzeme	45.3	33.1
2026-07-16 01:06:59	gps_ping	V-026	D-09	R-14	latgale	58.2	15.4
2026-07-16 01:06:56	speeding	V-041	D-22	R-11	vidzeme	98.6	30.8
2026-07-16 01:06:53	gps_ping	V-048	D-01	R-06	vidzeme	77.8	29.4
2026-07-16 01:06:52	gps_ping	V-027	D-12	R-15	riga	85.8	27.7