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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:32:09	trip_end	V-028	D-20	R-09	riga	34.5	38.4
2026-07-16 01:32:05	trip_start	V-048	D-06	R-14	latgale	70.9	27.2
2026-07-16 01:32:04	trip_end	V-041	D-03	R-15	riga	37.5	32.4
2026-07-16 01:32:00	gps_ping	V-047	D-26	R-08	latgale	77.6	14.4
2026-07-16 01:32:00	gps_ping	V-048	D-08	R-14	latgale	35.6	28.7
2026-07-16 01:31:57	engine_fault	V-022	D-26	R-07	riga	38.4	33.1
2026-07-16 01:31:55	trip_start	V-015	D-02	R-13	latgale	62.4	27.9
2026-07-16 01:31:52	gps_ping	V-009	D-09	R-11	vidzeme	61.1	35.5
2026-07-16 01:31:51	gps_ping	V-005	D-16	R-05	riga	73.7	15.6
2026-07-16 01:31:51	gps_ping	V-010	D-22	R-14	latgale	44.8	27.7
2026-07-16 01:31:48	gps_ping	V-040	D-26	R-08	latgale	75.8	26.7
2026-07-16 01:31:46	gps_ping	V-003	D-26	R-08	latgale	46.5	26.8
2026-07-16 01:31:44	trip_end	V-003	D-28	R-04	vidzeme	43.2	24.7
2026-07-16 01:31:44	trip_start	V-025	D-15	R-07	riga	60.2	39.4
2026-07-16 01:31:40	trip_start	V-039	D-10	R-15	riga	96.3	15.2
2026-07-16 01:31:32	trip_start	V-031	D-28	R-07	riga	49.7	30.4
2026-07-16 01:31:32	refuel	V-026	D-08	R-10	latgale	0	17.1
2026-07-16 01:31:30	gps_ping	V-045	D-10	R-05	riga	48.6	12.9
2026-07-16 01:31:27	engine_fault	V-047	D-09	R-09	riga	73.3	18
2026-07-16 01:31:24	harsh_braking	V-038	D-04	R-03	kurzeme	30.4	28.1
2026-07-16 01:31:21	gps_ping	V-009	D-29	R-02	kurzeme	62.4	40.5
2026-07-16 01:31:14	gps_ping	V-039	D-09	R-10	latgale	32.5	13.4
2026-07-16 01:31:14	trip_end	V-007	D-04	R-01	kurzeme	76.8	14
2026-07-16 01:31:09	trip_end	V-023	D-16	R-04	vidzeme	41.1	38.3
2026-07-16 01:31:06	harsh_braking	V-006	D-07	R-15	riga	43.9	35.6
2026-07-16 01:31:02	gps_ping	V-014	D-21	R-09	riga	81.4	30.6
2026-07-16 01:31:02	gps_ping	V-035	D-22	R-02	kurzeme	64.6	33.5
2026-07-16 01:31:01	trip_end	V-018	D-10	R-04	vidzeme	28.3	11.5
2026-07-16 01:30:59	gps_ping	V-001	D-09	R-01	kurzeme	90.2	34.2
2026-07-16 01:30:58	gps_ping	V-042	D-11	R-13	latgale	68.7	38.7
2026-07-16 01:30:54	speeding	V-011	D-29	R-08	latgale	42.6	16.4
2026-07-16 01:30:51	speeding	V-043	D-03	R-06	vidzeme	74.7	30.4
2026-07-16 01:30:51	gps_ping	V-009	D-26	R-15	riga	49.6	32.7
2026-07-16 01:30:41	trip_end	V-044	D-15	R-04	vidzeme	64	22.7
2026-07-16 01:30:39	trip_start	V-019	D-26	R-14	latgale	70	33.5
2026-07-16 01:30:35	gps_ping	V-013	D-15	R-08	latgale	52.4	16.2
2026-07-16 01:30:33	trip_end	V-022	D-28	R-13	latgale	32.8	31.4
2026-07-16 01:30:25	gps_ping	V-036	D-20	R-06	vidzeme	61.6	25.7
2026-07-16 01:30:25	speeding	V-005	D-24	R-04	vidzeme	14.7	14.2
2026-07-16 01:30:23	gps_ping	V-030	D-21	R-01	kurzeme	59.9	16.3
2026-07-16 01:30:15	gps_ping	V-014	D-16	R-08	latgale	20.8	32.5
2026-07-16 01:30:13	gps_ping	V-014	D-26	R-11	vidzeme	66.5	33.5
2026-07-16 01:30:12	trip_end	V-011	D-13	R-13	latgale	83.2	15.5
2026-07-16 01:30:11	trip_start	V-020	D-16	R-12	kurzeme	64.1	25.9
2026-07-16 01:30:09	gps_ping	V-036	D-22	R-04	vidzeme	29	30
2026-07-16 01:30:08	gps_ping	V-049	D-07	R-09	riga	59.7	27.9
2026-07-16 01:30:07	gps_ping	V-014	D-20	R-05	riga	27.5	31.4
2026-07-16 01:30:04	refuel	V-038	D-03	R-03	kurzeme	0	32.3
2026-07-16 01:29:59	trip_end	V-038	D-21	R-01	kurzeme	41.6	30.1
2026-07-16 01:29:58	trip_start	V-038	D-16	R-15	riga	82.3	28.9