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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:45:38	gps_ping	V-009	D-18	R-13	latgale	63.3	33.1
2026-07-16 01:45:37	gps_ping	V-015	D-03	R-13	latgale	36.6	31
2026-07-16 01:45:35	engine_fault	V-027	D-05	R-15	riga	35.2	30.1
2026-07-16 01:45:23	gps_ping	V-038	D-18	R-11	vidzeme	30.7	28.3
2026-07-16 01:45:20	gps_ping	V-043	D-09	R-09	riga	52.4	28.2
2026-07-16 01:45:20	gps_ping	V-037	D-14	R-02	kurzeme	36.9	27.4
2026-07-16 01:45:18	gps_ping	V-040	D-08	R-12	kurzeme	25.6	36.4
2026-07-16 01:45:14	trip_end	V-002	D-20	R-13	latgale	79.6	33.2
2026-07-16 01:45:12	speeding	V-033	D-05	R-13	latgale	80	25.1
2026-07-16 01:45:12	gps_ping	V-009	D-13	R-04	vidzeme	47.7	35.7
2026-07-16 01:45:11	gps_ping	V-008	D-04	R-06	vidzeme	43.1	30.7
2026-07-16 01:45:10	trip_end	V-021	D-03	R-12	kurzeme	49.9	28.3
2026-07-16 01:45:08	gps_ping	V-032	D-03	R-11	vidzeme	62.7	14.2
2026-07-16 01:45:05	gps_ping	V-046	D-28	R-02	kurzeme	41.4	31.6
2026-07-16 01:45:04	trip_end	V-034	D-06	R-04	vidzeme	43	33.2
2026-07-16 01:44:59	gps_ping	V-038	D-04	R-15	riga	53.5	27.2
2026-07-16 01:44:57	gps_ping	V-011	D-02	R-08	latgale	54.9	11.5
2026-07-16 01:44:50	idle	V-009	D-30	R-11	vidzeme	0	36.4
2026-07-16 01:44:50	gps_ping	V-021	D-09	R-15	riga	74.1	31.8
2026-07-16 01:44:49	gps_ping	V-014	D-05	R-04	vidzeme	27	30.5
2026-07-16 01:44:39	trip_start	V-019	D-09	R-05	riga	42	30.7
2026-07-16 01:44:35	speeding	V-043	D-25	R-10	latgale	33.8	31.3
2026-07-16 01:44:28	gps_ping	V-010	D-19	R-15	riga	22.2	26.8
2026-07-16 01:44:25	gps_ping	V-011	D-04	R-13	latgale	73.7	13.9
2026-07-16 01:44:24	speeding	V-002	D-04	R-15	riga	80.9	32.8
2026-07-16 01:44:21	trip_start	V-020	D-08	R-03	kurzeme	38.4	23.3
2026-07-16 01:44:18	gps_ping	V-019	D-26	R-08	latgale	85.7	27.4
2026-07-16 01:44:18	engine_fault	V-009	D-10	R-03	kurzeme	35.5	26.6
2026-07-16 01:44:16	harsh_braking	V-031	D-04	R-02	kurzeme	44.4	29.8
2026-07-16 01:44:12	gps_ping	V-015	D-14	R-10	latgale	57.9	32.2
2026-07-16 01:44:12	gps_ping	V-018	D-23	R-12	kurzeme	22.2	17.2
2026-07-16 01:44:12	engine_fault	V-030	D-02	R-04	vidzeme	37.1	14.9
2026-07-16 01:44:10	gps_ping	V-049	D-29	R-14	latgale	74.4	33.5
2026-07-16 01:44:09	gps_ping	V-001	D-09	R-12	kurzeme	75.7	32.1
2026-07-16 01:44:03	trip_start	V-038	D-18	R-08	latgale	82.1	23.2
2026-07-16 01:44:01	gps_ping	V-028	D-21	R-11	vidzeme	18.9	29.4
2026-07-16 01:43:54	refuel	V-026	D-28	R-10	latgale	0	15.1
2026-07-16 01:43:54	speeding	V-001	D-27	R-12	kurzeme	80.4	34.2
2026-07-16 01:43:51	gps_ping	V-019	D-25	R-10	latgale	81.5	27.7
2026-07-16 01:43:46	gps_ping	V-036	D-06	R-08	latgale	42.7	27.1
2026-07-16 01:43:45	refuel	V-010	D-20	R-08	latgale	0	33.9
2026-07-16 01:43:42	speeding	V-045	D-18	R-10	latgale	42.7	12.4
2026-07-16 01:43:40	gps_ping	V-038	D-03	R-08	latgale	33	26.6
2026-07-16 01:43:35	gps_ping	V-031	D-29	R-15	riga	55.5	33.5
2026-07-16 01:43:33	trip_start	V-032	D-24	R-05	riga	42.8	11.8
2026-07-16 01:43:33	idle	V-040	D-02	R-10	latgale	0	26.5
2026-07-16 01:43:32	harsh_braking	V-038	D-29	R-11	vidzeme	43.4	31.4
2026-07-16 01:43:29	gps_ping	V-035	D-13	R-09	riga	45.2	32.6
2026-07-16 01:43:26	gps_ping	V-023	D-02	R-04	vidzeme	60.2	35.1
2026-07-16 01:43:24	gps_ping	V-040	D-02	R-03	kurzeme	35.4	35.5