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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:29:55	harsh_braking	V-040	D-09	R-13	latgale	51.6	32
2026-07-16 01:29:54	idle	V-036	D-08	R-07	riga	0	26.7
2026-07-16 01:29:47	gps_ping	V-049	D-27	R-02	kurzeme	23.6	34.6
2026-07-16 01:29:47	gps_ping	V-044	D-17	R-03	kurzeme	49	32.9
2026-07-16 01:29:43	trip_end	V-001	D-09	R-10	latgale	61.4	32.5
2026-07-16 01:29:43	gps_ping	V-035	D-16	R-05	riga	39.2	33.4
2026-07-16 01:29:42	trip_start	V-049	D-03	R-15	riga	42.7	34.5
2026-07-16 01:29:41	gps_ping	V-005	D-30	R-02	kurzeme	87.2	14.4
2026-07-16 01:29:41	gps_ping	V-016	D-09	R-10	latgale	68.8	36.9
2026-07-16 01:29:36	idle	V-023	D-20	R-13	latgale	0	32.5
2026-07-16 01:29:36	gps_ping	V-009	D-15	R-05	riga	87.5	28.4
2026-07-16 01:29:35	trip_start	V-002	D-16	R-12	kurzeme	63.9	34.7
2026-07-16 01:29:34	gps_ping	V-029	D-26	R-06	vidzeme	25.6	26.9
2026-07-16 01:29:30	gps_ping	V-030	D-30	R-12	kurzeme	84.6	15.5
2026-07-16 01:29:25	gps_ping	V-050	D-06	R-12	kurzeme	88.6	25.5
2026-07-16 01:29:22	gps_ping	V-042	D-15	R-07	riga	37.2	29.9
2026-07-16 01:29:18	gps_ping	V-022	D-16	R-06	vidzeme	43.8	29.3
2026-07-16 01:29:07	gps_ping	V-036	D-09	R-08	latgale	23.2	27.9
2026-07-16 01:29:07	gps_ping	V-033	D-08	R-07	riga	59.1	31.2
2026-07-16 01:28:54	gps_ping	V-011	D-22	R-08	latgale	61	19.2
2026-07-16 01:28:47	gps_ping	V-035	D-25	R-12	kurzeme	25.8	34.3
2026-07-16 01:28:45	gps_ping	V-044	D-30	R-12	kurzeme	24.7	30.5
2026-07-16 01:28:43	trip_start	V-027	D-23	R-15	riga	27.6	33.1
2026-07-16 01:28:36	refuel	V-020	D-23	R-10	latgale	0	34
2026-07-16 01:28:36	gps_ping	V-002	D-11	R-04	vidzeme	22.2	27.6
2026-07-16 01:28:36	gps_ping	V-009	D-19	R-07	riga	61.7	33.8
2026-07-16 01:28:29	gps_ping	V-013	D-27	R-07	riga	32.9	15.2
2026-07-16 01:28:24	gps_ping	V-046	D-07	R-14	latgale	24.1	25.5
2026-07-16 01:28:24	gps_ping	V-036	D-16	R-03	kurzeme	45.7	32.3
2026-07-16 01:28:23	gps_ping	V-001	D-04	R-01	kurzeme	28.5	24.8
2026-07-16 01:28:22	gps_ping	V-019	D-09	R-07	riga	59.9	28.8
2026-07-16 01:28:21	gps_ping	V-028	D-19	R-13	latgale	72.9	34.3
2026-07-16 01:28:21	gps_ping	V-045	D-10	R-09	riga	71.4	14.6
2026-07-16 01:28:20	trip_end	V-050	D-11	R-01	kurzeme	77.4	24.8
2026-07-16 01:28:17	gps_ping	V-024	D-07	R-11	vidzeme	69.5	14.2
2026-07-16 01:28:14	gps_ping	V-001	D-02	R-15	riga	52.6	26.3
2026-07-16 01:28:13	refuel	V-031	D-12	R-15	riga	0	35.6
2026-07-16 01:28:03	gps_ping	V-030	D-14	R-02	kurzeme	84.8	12.2
2026-07-16 01:28:00	idle	V-008	D-10	R-06	vidzeme	0	23.1
2026-07-16 01:27:58	refuel	V-015	D-11	R-12	kurzeme	0	27.5
2026-07-16 01:27:56	gps_ping	V-014	D-24	R-02	kurzeme	22.2	39
2026-07-16 01:27:52	engine_fault	V-020	D-21	R-07	riga	20.5	31.6
2026-07-16 01:27:52	gps_ping	V-037	D-07	R-06	vidzeme	97.2	31.5
2026-07-16 01:27:51	gps_ping	V-037	D-30	R-06	vidzeme	54.3	35.5
2026-07-16 01:27:50	gps_ping	V-009	D-25	R-01	kurzeme	62.3	34.8
2026-07-16 01:27:42	gps_ping	V-001	D-13	R-08	latgale	97.1	30.1
2026-07-16 01:27:33	trip_end	V-047	D-11	R-02	kurzeme	74.1	14.9
2026-07-16 01:27:33	gps_ping	V-013	D-16	R-08	latgale	83.3	20.5
2026-07-16 01:27:32	gps_ping	V-015	D-14	R-04	vidzeme	65.7	26.7
2026-07-16 01:27:30	gps_ping	V-049	D-26	R-05	riga	71.1	33.1