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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:59:58	speeding	V-026	D-16	R-07	riga	26.4	15.6
2026-07-16 00:59:57	gps_ping	V-022	D-25	R-09	riga	53.4	28.2
2026-07-16 00:59:56	idle	V-004	D-02	R-01	kurzeme	0	27.7
2026-07-16 00:59:50	gps_ping	V-019	D-13	R-03	kurzeme	61.9	31
2026-07-16 00:59:44	trip_start	V-042	D-11	R-11	vidzeme	62.9	32.1
2026-07-16 00:59:42	gps_ping	V-048	D-14	R-12	kurzeme	30.9	24.5
2026-07-16 00:59:41	gps_ping	V-017	D-06	R-05	riga	63.6	25
2026-07-16 00:59:41	engine_fault	V-046	D-12	R-05	riga	80.1	29.5
2026-07-16 00:59:36	gps_ping	V-029	D-03	R-10	latgale	89.5	28.1
2026-07-16 00:59:35	refuel	V-043	D-25	R-02	kurzeme	0	32.9
2026-07-16 00:59:32	engine_fault	V-033	D-24	R-15	riga	56.5	36.9
2026-07-16 00:59:31	idle	V-040	D-22	R-10	latgale	0	33.8
2026-07-16 00:59:31	gps_ping	V-042	D-14	R-03	kurzeme	60.6	32.7
2026-07-16 00:59:27	gps_ping	V-016	D-17	R-04	vidzeme	15.2	37
2026-07-16 00:59:27	speeding	V-035	D-27	R-07	riga	54.4	34.5
2026-07-16 00:59:21	gps_ping	V-022	D-04	R-09	riga	28.9	33.7
2026-07-16 00:59:19	gps_ping	V-005	D-30	R-07	riga	31.5	13.4
2026-07-16 00:59:18	gps_ping	V-043	D-27	R-04	vidzeme	58.6	29.2
2026-07-16 00:59:10	gps_ping	V-027	D-01	R-10	latgale	35.6	33.2
2026-07-16 00:59:03	gps_ping	V-003	D-23	R-07	riga	80.2	29.2
2026-07-16 00:59:02	gps_ping	V-024	D-12	R-04	vidzeme	49.2	15.4
2026-07-16 00:58:53	speeding	V-007	D-18	R-11	vidzeme	90.4	10.9
2026-07-16 00:58:52	gps_ping	V-036	D-21	R-12	kurzeme	42.5	24.9
2026-07-16 00:58:51	gps_ping	V-042	D-16	R-11	vidzeme	36.2	34.1
2026-07-16 00:58:51	gps_ping	V-050	D-06	R-11	vidzeme	60.9	29.5
2026-07-16 00:58:49	gps_ping	V-035	D-18	R-07	riga	76.6	38.9
2026-07-16 00:58:49	refuel	V-022	D-24	R-14	latgale	0	26.3
2026-07-16 00:58:47	gps_ping	V-005	D-20	R-11	vidzeme	90.3	15.6
2026-07-16 00:58:47	gps_ping	V-015	D-30	R-01	kurzeme	70.3	29.2
2026-07-16 00:58:47	gps_ping	V-004	D-12	R-11	vidzeme	98.3	28
2026-07-16 00:58:43	gps_ping	V-014	D-17	R-03	kurzeme	47.9	30.9
2026-07-16 00:58:42	gps_ping	V-019	D-14	R-15	riga	54.6	28
2026-07-16 00:58:36	trip_start	V-031	D-28	R-15	riga	28.8	29.9
2026-07-16 00:58:35	refuel	V-028	D-01	R-07	riga	0	34.5
2026-07-16 00:58:35	refuel	V-023	D-05	R-13	latgale	0	27.4
2026-07-16 00:58:35	gps_ping	V-028	D-06	R-14	latgale	9.3	31.8
2026-07-16 00:58:33	trip_start	V-029	D-29	R-15	riga	36.4	31.4
2026-07-16 00:58:29	gps_ping	V-001	D-05	R-05	riga	36.7	25.1
2026-07-16 00:58:25	trip_start	V-034	D-22	R-12	kurzeme	28.1	23.1
2026-07-16 00:58:25	harsh_braking	V-043	D-18	R-14	latgale	69.5	25.7
2026-07-16 00:58:24	gps_ping	V-029	D-20	R-05	riga	80.8	32
2026-07-16 00:58:24	speeding	V-027	D-11	R-02	kurzeme	75.8	20.2
2026-07-16 00:58:22	refuel	V-023	D-07	R-05	riga	0	31.7
2026-07-16 00:58:19	refuel	V-012	D-04	R-01	kurzeme	0	28.2
2026-07-16 00:58:14	gps_ping	V-037	D-28	R-09	riga	79.4	35.6
2026-07-16 00:58:12	refuel	V-024	D-10	R-07	riga	0	10.9
2026-07-16 00:58:10	gps_ping	V-025	D-12	R-11	vidzeme	49	27.2
2026-07-16 00:58:09	gps_ping	V-039	D-23	R-13	latgale	70.3	14.1
2026-07-16 00:58:07	idle	V-036	D-18	R-11	vidzeme	0	23.9
2026-07-16 00:57:59	gps_ping	V-014	D-02	R-15	riga	23.5	27.4