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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:53:00	gps_ping	V-046	D-05	R-13	latgale	45	26.8
2026-07-16 02:53:00	gps_ping	V-025	D-06	R-06	vidzeme	77.2	20.7
2026-07-16 02:52:59	gps_ping	V-025	D-03	R-02	kurzeme	65.5	25.7
2026-07-16 02:52:58	idle	V-043	D-16	R-02	kurzeme	0	30.6
2026-07-16 02:52:56	trip_end	V-001	D-23	R-12	kurzeme	93.4	28.2
2026-07-16 02:52:53	gps_ping	V-044	D-09	R-02	kurzeme	75.5	36.7
2026-07-16 02:52:50	gps_ping	V-049	D-06	R-03	kurzeme	75.3	31.6
2026-07-16 02:52:44	trip_start	V-018	D-02	R-08	latgale	40.6	13.3
2026-07-16 02:52:40	gps_ping	V-031	D-16	R-15	riga	38.6	30.3
2026-07-16 02:52:40	gps_ping	V-031	D-04	R-13	latgale	47.2	26
2026-07-16 02:52:37	gps_ping	V-016	D-27	R-05	riga	51.9	34.7
2026-07-16 02:52:31	harsh_braking	V-050	D-28	R-05	riga	50.2	27.2
2026-07-16 02:52:27	trip_start	V-041	D-09	R-08	latgale	83.8	30.6
2026-07-16 02:52:23	trip_start	V-009	D-30	R-04	vidzeme	42.3	40.1
2026-07-16 02:52:23	engine_fault	V-008	D-25	R-14	latgale	46.7	24.2
2026-07-16 02:52:22	refuel	V-045	D-23	R-07	riga	0	11.3
2026-07-16 02:52:21	gps_ping	V-040	D-12	R-12	kurzeme	44.5	29.2
2026-07-16 02:52:21	refuel	V-018	D-25	R-06	vidzeme	0	17.5
2026-07-16 02:52:20	trip_start	V-022	D-15	R-15	riga	11.9	29.7
2026-07-16 02:52:20	trip_end	V-037	D-21	R-05	riga	58.9	29.1
2026-07-16 02:52:15	speeding	V-005	D-16	R-14	latgale	42.2	15.2
2026-07-16 02:52:14	gps_ping	V-004	D-27	R-03	kurzeme	38.2	31
2026-07-16 02:52:13	gps_ping	V-020	D-21	R-12	kurzeme	38.3	29
2026-07-16 02:52:11	idle	V-038	D-21	R-09	riga	0	30.3
2026-07-16 02:52:10	trip_end	V-024	D-02	R-15	riga	93.6	12
2026-07-16 02:52:05	gps_ping	V-048	D-19	R-03	kurzeme	62.2	30
2026-07-16 02:52:03	gps_ping	V-022	D-02	R-15	riga	79.9	20.9
2026-07-16 02:51:57	gps_ping	V-020	D-14	R-02	kurzeme	34.8	27.6
2026-07-16 02:51:53	gps_ping	V-006	D-29	R-14	latgale	67.2	31.3
2026-07-16 02:51:52	gps_ping	V-048	D-07	R-04	vidzeme	38.3	28.8
2026-07-16 02:51:47	gps_ping	V-019	D-17	R-12	kurzeme	30.6	24.9
2026-07-16 02:51:45	gps_ping	V-047	D-28	R-08	latgale	60.1	14.8
2026-07-16 02:51:45	gps_ping	V-045	D-21	R-10	latgale	60.4	14.5
2026-07-16 02:51:44	gps_ping	V-011	D-19	R-08	latgale	38.4	14.8
2026-07-16 02:51:43	gps_ping	V-005	D-29	R-04	vidzeme	47.6	16.8
2026-07-16 02:51:43	idle	V-048	D-16	R-08	latgale	0	33.6
2026-07-16 02:51:43	trip_end	V-027	D-03	R-13	latgale	43.9	30.4
2026-07-16 02:51:43	gps_ping	V-030	D-22	R-04	vidzeme	36	14.4
2026-07-16 02:51:40	speeding	V-010	D-05	R-13	latgale	53.7	27.5
2026-07-16 02:51:36	speeding	V-047	D-06	R-04	vidzeme	37.4	13.6
2026-07-16 02:51:32	gps_ping	V-001	D-29	R-07	riga	40.2	26.8
2026-07-16 02:51:24	harsh_braking	V-049	D-02	R-15	riga	26.8	34.2
2026-07-16 02:51:21	engine_fault	V-031	D-21	R-12	kurzeme	103.4	28.6
2026-07-16 02:51:21	harsh_braking	V-010	D-19	R-09	riga	46	32.9
2026-07-16 02:51:17	gps_ping	V-025	D-18	R-07	riga	76.9	29.8
2026-07-16 02:51:13	harsh_braking	V-025	D-27	R-06	vidzeme	55.1	31
2026-07-16 02:51:10	gps_ping	V-001	D-22	R-08	latgale	45.4	29.6
2026-07-16 02:51:04	gps_ping	V-021	D-10	R-13	latgale	38.8	35
2026-07-16 02:51:04	refuel	V-019	D-24	R-09	riga	0	28.6
2026-07-16 02:50:59	gps_ping	V-023	D-22	R-08	latgale	69.6	34.5