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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:25:11	gps_ping	V-022	D-15	R-07	riga	91.9	28.6
2026-07-16 01:25:05	trip_start	V-010	D-03	R-05	riga	59.7	31.6
2026-07-16 01:25:00	gps_ping	V-035	D-04	R-08	latgale	79.6	30.3
2026-07-16 01:24:59	trip_start	V-050	D-25	R-06	vidzeme	62.3	19.3
2026-07-16 01:24:55	gps_ping	V-016	D-20	R-04	vidzeme	58.3	34.4
2026-07-16 01:24:50	gps_ping	V-038	D-14	R-13	latgale	38.2	25.8
2026-07-16 01:24:47	idle	V-039	D-29	R-02	kurzeme	0	15.8
2026-07-16 01:24:47	gps_ping	V-018	D-11	R-12	kurzeme	55.9	13.6
2026-07-16 01:24:42	trip_start	V-011	D-24	R-11	vidzeme	52.7	13.6
2026-07-16 01:24:39	gps_ping	V-021	D-22	R-04	vidzeme	53.2	29.5
2026-07-16 01:24:36	gps_ping	V-029	D-26	R-06	vidzeme	78.9	26.4
2026-07-16 01:24:32	gps_ping	V-013	D-12	R-14	latgale	52.2	14
2026-07-16 01:24:31	idle	V-043	D-30	R-13	latgale	0	27.1
2026-07-16 01:24:31	trip_end	V-023	D-08	R-14	latgale	31.1	32.8
2026-07-16 01:24:29	gps_ping	V-010	D-23	R-13	latgale	39.8	26.6
2026-07-16 01:24:25	refuel	V-024	D-23	R-14	latgale	0	15
2026-07-16 01:24:22	engine_fault	V-039	D-20	R-15	riga	41.5	12.3
2026-07-16 01:24:21	gps_ping	V-049	D-21	R-14	latgale	57.3	29.5
2026-07-16 01:24:17	gps_ping	V-039	D-04	R-15	riga	42.7	11.6
2026-07-16 01:24:17	gps_ping	V-037	D-28	R-10	latgale	25.2	32.4
2026-07-16 01:24:15	idle	V-013	D-04	R-06	vidzeme	0	14.2
2026-07-16 01:24:14	gps_ping	V-030	D-12	R-05	riga	35.6	13.8
2026-07-16 01:24:13	engine_fault	V-014	D-16	R-12	kurzeme	46.3	33.4
2026-07-16 01:24:09	trip_end	V-018	D-21	R-05	riga	83.6	12.9
2026-07-16 01:24:00	gps_ping	V-009	D-27	R-01	kurzeme	70.7	38.1
2026-07-16 01:24:00	gps_ping	V-019	D-25	R-04	vidzeme	43	25.7
2026-07-16 01:23:59	gps_ping	V-005	D-30	R-03	kurzeme	78.3	14.9
2026-07-16 01:23:58	gps_ping	V-007	D-11	R-11	vidzeme	23.5	14
2026-07-16 01:23:49	gps_ping	V-025	D-15	R-12	kurzeme	39.8	32.2
2026-07-16 01:23:49	gps_ping	V-011	D-21	R-11	vidzeme	48.7	20
2026-07-16 01:23:49	refuel	V-009	D-18	R-04	vidzeme	0	36.4
2026-07-16 01:23:42	gps_ping	V-043	D-23	R-07	riga	51	32.7
2026-07-16 01:23:36	gps_ping	V-018	D-26	R-05	riga	92.8	15.5
2026-07-16 01:23:36	gps_ping	V-017	D-27	R-08	latgale	68.9	30.4
2026-07-16 01:23:32	gps_ping	V-032	D-05	R-05	riga	67	16
2026-07-16 01:23:29	trip_start	V-014	D-26	R-11	vidzeme	82.6	35.8
2026-07-16 01:23:28	gps_ping	V-032	D-17	R-10	latgale	43.4	12.6
2026-07-16 01:23:22	gps_ping	V-014	D-10	R-13	latgale	56.6	36.4
2026-07-16 01:23:19	gps_ping	V-035	D-16	R-03	kurzeme	48.4	36.8
2026-07-16 01:23:18	gps_ping	V-034	D-26	R-01	kurzeme	56.6	25.5
2026-07-16 01:23:14	speeding	V-007	D-28	R-12	kurzeme	75.4	15.1
2026-07-16 01:23:13	trip_end	V-003	D-30	R-03	kurzeme	82	25.3
2026-07-16 01:23:11	gps_ping	V-050	D-30	R-01	kurzeme	94.7	31.2
2026-07-16 01:23:09	gps_ping	V-027	D-18	R-02	kurzeme	49.2	29.1
2026-07-16 01:23:06	trip_start	V-001	D-25	R-02	kurzeme	54.6	25.8
2026-07-16 01:23:04	gps_ping	V-007	D-28	R-01	kurzeme	79.9	16.6
2026-07-16 01:22:52	refuel	V-048	D-24	R-09	riga	0	34.1
2026-07-16 01:22:50	gps_ping	V-045	D-19	R-08	latgale	26.3	11.3
2026-07-16 01:22:49	trip_start	V-033	D-23	R-03	kurzeme	80	32.2
2026-07-16 01:22:48	engine_fault	V-026	D-05	R-03	kurzeme	12.9	16.5