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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:18:28	engine_fault	V-017	D-06	R-02	kurzeme	37.9	28.1
2026-07-16 01:18:27	harsh_braking	V-008	D-07	R-14	latgale	63.8	26.8
2026-07-16 01:18:23	gps_ping	V-020	D-20	R-03	kurzeme	46.1	28.2
2026-07-16 01:18:21	speeding	V-040	D-08	R-14	latgale	36.8	41.2
2026-07-16 01:18:20	gps_ping	V-042	D-03	R-06	vidzeme	76.5	34.1
2026-07-16 01:18:17	gps_ping	V-029	D-20	R-12	kurzeme	88.7	24.3
2026-07-16 01:18:17	speeding	V-005	D-08	R-06	vidzeme	78.7	11.5
2026-07-16 01:18:15	gps_ping	V-013	D-02	R-07	riga	45.2	11.5
2026-07-16 01:18:13	engine_fault	V-035	D-13	R-03	kurzeme	28.3	24.3
2026-07-16 01:18:11	engine_fault	V-013	D-14	R-10	latgale	73.7	15.1
2026-07-16 01:18:11	speeding	V-014	D-05	R-14	latgale	37.6	39.8
2026-07-16 01:18:09	gps_ping	V-003	D-14	R-11	vidzeme	36.1	25.2
2026-07-16 01:18:03	gps_ping	V-011	D-23	R-09	riga	50	14
2026-07-16 01:17:58	refuel	V-045	D-21	R-07	riga	0	16.2
2026-07-16 01:17:58	gps_ping	V-034	D-23	R-13	latgale	25.5	20.5
2026-07-16 01:17:54	trip_start	V-018	D-21	R-06	vidzeme	58.8	12.8
2026-07-16 01:17:50	trip_start	V-043	D-06	R-01	kurzeme	42.7	23.5
2026-07-16 01:17:41	trip_start	V-033	D-09	R-14	latgale	57.3	33.1
2026-07-16 01:17:39	trip_end	V-006	D-15	R-04	vidzeme	11.6	34.2
2026-07-16 01:17:38	trip_start	V-043	D-20	R-11	vidzeme	75.5	33.9
2026-07-16 01:17:37	harsh_braking	V-019	D-16	R-10	latgale	49.2	32.8
2026-07-16 01:17:36	gps_ping	V-039	D-29	R-15	riga	52.4	17.6
2026-07-16 01:17:35	idle	V-031	D-08	R-15	riga	0	25.5
2026-07-16 01:17:33	gps_ping	V-046	D-26	R-01	kurzeme	70.9	31.2
2026-07-16 01:17:30	gps_ping	V-001	D-12	R-10	latgale	51.4	28.6
2026-07-16 01:17:24	gps_ping	V-014	D-01	R-04	vidzeme	60.9	32.9
2026-07-16 01:17:22	engine_fault	V-025	D-10	R-08	latgale	35.8	35.7
2026-07-16 01:17:18	gps_ping	V-004	D-07	R-14	latgale	41.8	32.7
2026-07-16 01:17:09	gps_ping	V-011	D-20	R-14	latgale	21.9	15.1
2026-07-16 01:17:07	gps_ping	V-045	D-22	R-15	riga	53	16.4
2026-07-16 01:17:07	gps_ping	V-014	D-15	R-10	latgale	59.6	32.3
2026-07-16 01:16:59	gps_ping	V-038	D-28	R-01	kurzeme	71.4	26.8
2026-07-16 01:16:57	gps_ping	V-021	D-01	R-11	vidzeme	52.6	35.6
2026-07-16 01:16:56	refuel	V-048	D-27	R-14	latgale	0	31.8
2026-07-16 01:16:55	gps_ping	V-046	D-03	R-07	riga	93.4	33.8
2026-07-16 01:16:52	refuel	V-006	D-04	R-06	vidzeme	0	31.2
2026-07-16 01:16:52	refuel	V-009	D-27	R-01	kurzeme	0	25.5
2026-07-16 01:16:49	gps_ping	V-003	D-15	R-15	riga	58	30.5
2026-07-16 01:16:45	gps_ping	V-019	D-29	R-05	riga	63.4	25.6
2026-07-16 01:16:41	gps_ping	V-034	D-15	R-11	vidzeme	45.3	27.3
2026-07-16 01:16:40	gps_ping	V-033	D-16	R-15	riga	58.3	29.5
2026-07-16 01:16:34	gps_ping	V-045	D-09	R-08	latgale	41.5	9.6
2026-07-16 01:16:32	gps_ping	V-017	D-13	R-13	latgale	75.4	27.8
2026-07-16 01:16:31	refuel	V-034	D-27	R-02	kurzeme	0	26.6
2026-07-16 01:16:28	gps_ping	V-019	D-07	R-09	riga	29.5	27.6
2026-07-16 01:16:27	gps_ping	V-010	D-09	R-05	riga	72.1	28.2
2026-07-16 01:16:26	gps_ping	V-009	D-12	R-06	vidzeme	38.8	31.9
2026-07-16 01:16:21	gps_ping	V-002	D-01	R-12	kurzeme	36	35.7
2026-07-16 01:16:14	harsh_braking	V-029	D-10	R-02	kurzeme	45.4	26.7
2026-07-16 01:16:13	gps_ping	V-038	D-16	R-15	riga	38.1	29.2