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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:07:34	gps_ping	V-046	D-10	R-02	kurzeme	47.7	23
2026-07-16 02:07:33	gps_ping	V-043	D-28	R-08	latgale	16.4	27.7
2026-07-16 02:07:31	gps_ping	V-023	D-02	R-09	riga	46.7	32.6
2026-07-16 02:07:26	harsh_braking	V-007	D-22	R-11	vidzeme	43.8	14.5
2026-07-16 02:07:21	gps_ping	V-036	D-13	R-09	riga	82.8	31.5
2026-07-16 02:07:21	gps_ping	V-030	D-05	R-12	kurzeme	83.7	13
2026-07-16 02:07:20	idle	V-014	D-29	R-03	kurzeme	0	28.2
2026-07-16 02:07:19	gps_ping	V-023	D-12	R-14	latgale	41.8	37.6
2026-07-16 02:07:17	gps_ping	V-005	D-30	R-07	riga	48.9	16.5
2026-07-16 02:07:17	gps_ping	V-033	D-27	R-08	latgale	88.5	31
2026-07-16 02:07:14	gps_ping	V-034	D-02	R-08	latgale	56.4	25.6
2026-07-16 02:07:10	gps_ping	V-041	D-01	R-07	riga	58.4	31.8
2026-07-16 02:07:02	gps_ping	V-028	D-15	R-06	vidzeme	29.9	36
2026-07-16 02:07:02	trip_start	V-001	D-07	R-07	riga	59.3	37
2026-07-16 02:06:57	gps_ping	V-022	D-27	R-13	latgale	60.4	29.1
2026-07-16 02:06:55	gps_ping	V-026	D-22	R-03	kurzeme	54.8	15.6
2026-07-16 02:06:55	gps_ping	V-019	D-01	R-12	kurzeme	60.3	34.5
2026-07-16 02:06:53	trip_start	V-030	D-24	R-11	vidzeme	46.1	8.7
2026-07-16 02:06:53	idle	V-032	D-02	R-02	kurzeme	0	11.8
2026-07-16 02:06:46	harsh_braking	V-029	D-26	R-07	riga	40.2	34.6
2026-07-16 02:06:45	refuel	V-007	D-17	R-13	latgale	0	14
2026-07-16 02:06:42	gps_ping	V-024	D-16	R-08	latgale	67.9	16.7
2026-07-16 02:06:41	trip_start	V-046	D-14	R-06	vidzeme	66.5	26
2026-07-16 02:06:38	refuel	V-010	D-12	R-06	vidzeme	0	30.1
2026-07-16 02:06:28	gps_ping	V-045	D-05	R-02	kurzeme	34.9	17.1
2026-07-16 02:06:24	gps_ping	V-045	D-26	R-11	vidzeme	57.5	11.2
2026-07-16 02:06:23	refuel	V-038	D-18	R-12	kurzeme	0	25.7
2026-07-16 02:06:21	idle	V-016	D-07	R-04	vidzeme	0	34
2026-07-16 02:06:18	trip_end	V-011	D-24	R-15	riga	31.4	11.2
2026-07-16 02:06:14	gps_ping	V-001	D-26	R-10	latgale	64.5	25.2
2026-07-16 02:06:12	gps_ping	V-005	D-14	R-02	kurzeme	86	15.4
2026-07-16 02:06:09	gps_ping	V-020	D-12	R-07	riga	32.2	30.8
2026-07-16 02:06:07	gps_ping	V-018	D-09	R-05	riga	79	13.3
2026-07-16 02:06:06	gps_ping	V-010	D-08	R-11	vidzeme	75.1	26.5
2026-07-16 02:06:06	refuel	V-032	D-27	R-05	riga	0	14.7
2026-07-16 02:06:00	trip_start	V-022	D-11	R-11	vidzeme	44.8	23.8
2026-07-16 02:05:59	refuel	V-033	D-12	R-09	riga	0	33.8
2026-07-16 02:05:59	gps_ping	V-038	D-12	R-06	vidzeme	71.8	23.7
2026-07-16 02:05:58	trip_end	V-049	D-30	R-08	latgale	65.3	33
2026-07-16 02:05:57	speeding	V-046	D-21	R-08	latgale	77.7	26.7
2026-07-16 02:05:57	gps_ping	V-003	D-18	R-08	latgale	43.4	27.2
2026-07-16 02:05:56	gps_ping	V-011	D-13	R-04	vidzeme	43.1	13.9
2026-07-16 02:05:54	idle	V-036	D-24	R-02	kurzeme	0	26.7
2026-07-16 02:05:53	gps_ping	V-035	D-25	R-10	latgale	44.2	33.2
2026-07-16 02:05:53	gps_ping	V-018	D-01	R-14	latgale	73.6	16.3
2026-07-16 02:05:52	harsh_braking	V-015	D-03	R-04	vidzeme	48.9	29.6
2026-07-16 02:05:48	trip_end	V-030	D-14	R-02	kurzeme	62	14.5
2026-07-16 02:05:38	gps_ping	V-014	D-18	R-14	latgale	20	28.5
2026-07-16 02:05:33	trip_end	V-020	D-03	R-01	kurzeme	70.6	30.4
2026-07-16 02:05:28	gps_ping	V-027	D-12	R-03	kurzeme	24	24.9