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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:22:45	trip_start	V-022	D-14	R-08	latgale	33.8	26.5
2026-07-16 01:22:39	gps_ping	V-047	D-26	R-13	latgale	57.7	15.3
2026-07-16 01:22:39	gps_ping	V-021	D-09	R-01	kurzeme	56.2	30.1
2026-07-16 01:22:34	idle	V-037	D-11	R-14	latgale	0	31.1
2026-07-16 01:22:34	trip_end	V-016	D-25	R-11	vidzeme	73.1	35.7
2026-07-16 01:22:33	harsh_braking	V-040	D-17	R-02	kurzeme	53.3	37
2026-07-16 01:22:27	trip_start	V-011	D-09	R-01	kurzeme	74.2	15.1
2026-07-16 01:22:24	gps_ping	V-027	D-10	R-08	latgale	72.8	28.1
2026-07-16 01:22:19	gps_ping	V-043	D-21	R-03	kurzeme	54	26.1
2026-07-16 01:22:19	gps_ping	V-035	D-07	R-15	riga	74.3	30.3
2026-07-16 01:22:18	trip_start	V-007	D-24	R-02	kurzeme	62.6	13.6
2026-07-16 01:22:14	idle	V-025	D-30	R-06	vidzeme	0	28.8
2026-07-16 01:22:12	gps_ping	V-040	D-17	R-02	kurzeme	31.7	34.1
2026-07-16 01:22:10	gps_ping	V-011	D-11	R-05	riga	30.8	11
2026-07-16 01:22:08	engine_fault	V-045	D-28	R-09	riga	73.9	16.7
2026-07-16 01:22:08	gps_ping	V-033	D-14	R-11	vidzeme	40.9	26.1
2026-07-16 01:22:06	gps_ping	V-037	D-04	R-08	latgale	86.3	29
2026-07-16 01:22:03	trip_start	V-018	D-04	R-03	kurzeme	57.4	13.2
2026-07-16 01:22:03	gps_ping	V-004	D-06	R-08	latgale	79.8	27.8
2026-07-16 01:22:03	harsh_braking	V-025	D-02	R-11	vidzeme	63.4	30.3
2026-07-16 01:22:00	harsh_braking	V-006	D-09	R-01	kurzeme	70.5	31
2026-07-16 01:21:58	gps_ping	V-010	D-06	R-04	vidzeme	11.2	26.6
2026-07-16 01:21:57	gps_ping	V-029	D-19	R-03	kurzeme	65	29.2
2026-07-16 01:21:55	gps_ping	V-027	D-17	R-07	riga	49.7	32.3
2026-07-16 01:21:54	harsh_braking	V-018	D-30	R-14	latgale	47.4	12.2
2026-07-16 01:21:49	trip_start	V-002	D-08	R-07	riga	26.2	37.8
2026-07-16 01:21:44	gps_ping	V-023	D-10	R-03	kurzeme	59.3	35.1
2026-07-16 01:21:44	gps_ping	V-022	D-18	R-12	kurzeme	40.8	26.1
2026-07-16 01:21:41	gps_ping	V-025	D-30	R-12	kurzeme	83.8	27.8
2026-07-16 01:21:41	trip_end	V-002	D-07	R-06	vidzeme	29.2	36.3
2026-07-16 01:21:40	gps_ping	V-045	D-13	R-07	riga	46	12.6
2026-07-16 01:21:35	gps_ping	V-017	D-07	R-10	latgale	78.9	39.4
2026-07-16 01:21:35	gps_ping	V-034	D-23	R-08	latgale	20	27.3
2026-07-16 01:21:30	gps_ping	V-009	D-23	R-12	kurzeme	38	36.2
2026-07-16 01:21:28	engine_fault	V-044	D-24	R-08	latgale	51.7	35.1
2026-07-16 01:21:23	gps_ping	V-013	D-18	R-02	kurzeme	87.3	14.4
2026-07-16 01:21:23	gps_ping	V-040	D-21	R-05	riga	40	37.1
2026-07-16 01:21:23	trip_end	V-050	D-14	R-09	riga	31.6	25.1
2026-07-16 01:21:11	gps_ping	V-006	D-03	R-10	latgale	37.1	33.3
2026-07-16 01:21:08	speeding	V-032	D-06	R-12	kurzeme	73.3	14.8
2026-07-16 01:21:07	gps_ping	V-032	D-22	R-08	latgale	94.5	13.9
2026-07-16 01:21:00	gps_ping	V-050	D-15	R-09	riga	56.6	32.2
2026-07-16 01:21:00	gps_ping	V-026	D-23	R-03	kurzeme	93.6	10.1
2026-07-16 01:20:58	gps_ping	V-007	D-05	R-08	latgale	60.1	12.9
2026-07-16 01:20:57	engine_fault	V-013	D-09	R-05	riga	70	13.1
2026-07-16 01:20:55	gps_ping	V-038	D-09	R-15	riga	84.6	30
2026-07-16 01:20:52	gps_ping	V-017	D-22	R-05	riga	41.4	32.4
2026-07-16 01:20:51	gps_ping	V-001	D-04	R-09	riga	25.7	28.2
2026-07-16 01:20:51	trip_end	V-050	D-25	R-08	latgale	40	32
2026-07-16 01:20:50	gps_ping	V-042	D-19	R-01	kurzeme	49.3	33.4