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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:44:20	trip_start	V-044	D-27	R-06	vidzeme	21.6	30.9
2026-07-16 00:44:17	gps_ping	V-047	D-26	R-09	riga	43.3	17
2026-07-16 00:44:06	gps_ping	V-009	D-24	R-09	riga	43.2	31.2
2026-07-16 00:44:00	gps_ping	V-019	D-25	R-13	latgale	84.1	26.5
2026-07-16 00:43:57	gps_ping	V-043	D-24	R-05	riga	44.8	26.8
2026-07-16 00:43:56	gps_ping	V-022	D-23	R-01	kurzeme	95.4	28.3
2026-07-16 00:43:55	refuel	V-039	D-07	R-06	vidzeme	0	16.6
2026-07-16 00:43:46	gps_ping	V-047	D-07	R-11	vidzeme	47.4	15.5
2026-07-16 00:43:45	gps_ping	V-030	D-24	R-06	vidzeme	60.2	13
2026-07-16 00:43:41	trip_start	V-033	D-15	R-09	riga	35.9	27.5
2026-07-16 00:43:40	refuel	V-005	D-04	R-03	kurzeme	0	15.1
2026-07-16 00:43:36	gps_ping	V-010	D-13	R-10	latgale	66.8	28.1
2026-07-16 00:43:35	trip_end	V-009	D-18	R-06	vidzeme	40.1	35.9
2026-07-16 00:43:35	trip_end	V-049	D-08	R-12	kurzeme	58.1	33.6
2026-07-16 00:43:32	gps_ping	V-016	D-19	R-01	kurzeme	83.5	33.1
2026-07-16 00:43:31	refuel	V-039	D-09	R-02	kurzeme	0	9
2026-07-16 00:43:30	gps_ping	V-031	D-14	R-14	latgale	43	30.6
2026-07-16 00:43:26	gps_ping	V-007	D-28	R-06	vidzeme	50.5	16.6
2026-07-16 00:43:22	gps_ping	V-033	D-08	R-01	kurzeme	51.7	36.9
2026-07-16 00:43:20	gps_ping	V-001	D-17	R-06	vidzeme	55.4	23.2
2026-07-16 00:43:18	idle	V-041	D-11	R-15	riga	0	26.5
2026-07-16 00:43:14	refuel	V-019	D-20	R-04	vidzeme	0	26.2
2026-07-16 00:43:12	gps_ping	V-015	D-12	R-11	vidzeme	38.6	37.4
2026-07-16 00:43:09	gps_ping	V-041	D-19	R-02	kurzeme	23.9	31.4
2026-07-16 00:43:08	gps_ping	V-040	D-07	R-11	vidzeme	73.4	32.9
2026-07-16 00:43:04	gps_ping	V-014	D-14	R-03	kurzeme	37	31.7
2026-07-16 00:43:03	trip_end	V-031	D-09	R-12	kurzeme	49.5	26.3
2026-07-16 00:43:01	gps_ping	V-048	D-09	R-09	riga	90.5	30.8
2026-07-16 00:43:00	gps_ping	V-049	D-12	R-04	vidzeme	38.5	30.6
2026-07-16 00:42:59	speeding	V-002	D-25	R-07	riga	49.5	29.3
2026-07-16 00:42:59	gps_ping	V-023	D-15	R-13	latgale	45.3	32.6
2026-07-16 00:42:50	gps_ping	V-009	D-24	R-11	vidzeme	40.3	35.6
2026-07-16 00:42:49	refuel	V-017	D-08	R-07	riga	0	26.1
2026-07-16 00:42:48	gps_ping	V-011	D-29	R-01	kurzeme	38.6	10.1
2026-07-16 00:42:42	gps_ping	V-043	D-07	R-14	latgale	86	27
2026-07-16 00:42:35	refuel	V-016	D-03	R-12	kurzeme	0	37.8
2026-07-16 00:42:32	gps_ping	V-026	D-20	R-08	latgale	94.8	10.8
2026-07-16 00:42:31	trip_end	V-006	D-03	R-02	kurzeme	76	23.9
2026-07-16 00:42:18	refuel	V-030	D-15	R-01	kurzeme	0	11.7
2026-07-16 00:42:16	speeding	V-012	D-07	R-12	kurzeme	45.5	29.4
2026-07-16 00:42:16	gps_ping	V-007	D-17	R-12	kurzeme	23.6	15
2026-07-16 00:42:13	gps_ping	V-050	D-20	R-05	riga	77.4	28.5
2026-07-16 00:42:13	trip_start	V-020	D-25	R-02	kurzeme	84.3	29.7
2026-07-16 00:42:12	refuel	V-004	D-05	R-09	riga	0	26.2
2026-07-16 00:42:08	gps_ping	V-004	D-03	R-03	kurzeme	71.7	20.3
2026-07-16 00:42:06	gps_ping	V-029	D-08	R-15	riga	75.3	30.6
2026-07-16 00:42:06	trip_start	V-040	D-15	R-15	riga	78.5	34.8
2026-07-16 00:42:03	harsh_braking	V-005	D-13	R-08	latgale	37.6	16.1
2026-07-16 00:42:03	engine_fault	V-031	D-09	R-08	latgale	63	29.5
2026-07-16 00:42:03	gps_ping	V-036	D-19	R-10	latgale	95.7	25.3