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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 03:01:47	harsh_braking	V-042	D-16	R-06	vidzeme	43.8	33.7
2026-07-16 03:01:44	gps_ping	V-022	D-16	R-01	kurzeme	41.3	32.7
2026-07-16 03:01:44	speeding	V-033	D-24	R-09	riga	82.2	29.7
2026-07-16 03:01:36	gps_ping	V-025	D-05	R-01	kurzeme	79.3	29.6
2026-07-16 03:01:34	gps_ping	V-040	D-02	R-08	latgale	39.5	27.7
2026-07-16 03:01:34	gps_ping	V-005	D-04	R-09	riga	64.1	16.1
2026-07-16 03:01:32	engine_fault	V-007	D-25	R-15	riga	78.7	12.4
2026-07-16 03:01:18	trip_end	V-009	D-06	R-08	latgale	36.5	31.6
2026-07-16 03:01:17	gps_ping	V-044	D-11	R-08	latgale	51.9	26.8
2026-07-16 03:01:14	harsh_braking	V-006	D-19	R-02	kurzeme	40.6	28.7
2026-07-16 03:01:14	gps_ping	V-008	D-08	R-14	latgale	24.5	27.9
2026-07-16 03:01:11	gps_ping	V-028	D-15	R-15	riga	83	25.7
2026-07-16 03:01:10	gps_ping	V-011	D-16	R-03	kurzeme	86.3	20.5
2026-07-16 03:01:02	engine_fault	V-016	D-30	R-04	vidzeme	36.7	34.4
2026-07-16 03:01:00	trip_start	V-016	D-14	R-04	vidzeme	43.4	36.2
2026-07-16 03:00:58	speeding	V-004	D-18	R-07	riga	82.6	24.5
2026-07-16 03:00:55	gps_ping	V-043	D-01	R-07	riga	38.5	29.6
2026-07-16 03:00:54	gps_ping	V-009	D-03	R-14	latgale	61.8	31.7
2026-07-16 03:00:52	gps_ping	V-037	D-10	R-07	riga	85.4	28.3
2026-07-16 03:00:47	gps_ping	V-011	D-11	R-11	vidzeme	41.5	11.5
2026-07-16 03:00:45	gps_ping	V-031	D-04	R-14	latgale	28.1	27.1
2026-07-16 03:00:43	gps_ping	V-028	D-05	R-10	latgale	87.6	38.4
2026-07-16 03:00:39	trip_start	V-030	D-27	R-06	vidzeme	90.4	16.9
2026-07-16 03:00:37	speeding	V-050	D-05	R-03	kurzeme	46.5	25.9
2026-07-16 03:00:31	gps_ping	V-010	D-01	R-13	latgale	90.5	32
2026-07-16 03:00:22	trip_end	V-034	D-24	R-13	latgale	89.8	34.9
2026-07-16 03:00:22	harsh_braking	V-042	D-09	R-14	latgale	53.7	34.5
2026-07-16 03:00:20	gps_ping	V-047	D-17	R-11	vidzeme	37.4	10.8
2026-07-16 03:00:12	gps_ping	V-001	D-07	R-12	kurzeme	72.7	33.2
2026-07-16 03:00:11	gps_ping	V-036	D-09	R-05	riga	36.6	28
2026-07-16 03:00:10	harsh_braking	V-015	D-25	R-09	riga	57.2	27.4
2026-07-16 03:00:10	trip_end	V-044	D-19	R-09	riga	61.4	26.8
2026-07-16 03:00:10	trip_end	V-047	D-06	R-07	riga	50.1	11.1
2026-07-16 03:00:10	engine_fault	V-020	D-30	R-07	riga	21.5	28.5
2026-07-16 03:00:02	gps_ping	V-009	D-24	R-06	vidzeme	72.1	33.3
2026-07-16 02:59:59	gps_ping	V-048	D-23	R-12	kurzeme	92.2	23.1
2026-07-16 02:59:47	idle	V-028	D-27	R-14	latgale	0	31.1
2026-07-16 02:59:45	refuel	V-001	D-29	R-15	riga	0	28.7
2026-07-16 02:59:44	gps_ping	V-019	D-21	R-03	kurzeme	92.5	25
2026-07-16 02:59:44	gps_ping	V-046	D-05	R-10	latgale	75.1	27.4
2026-07-16 02:59:42	trip_end	V-039	D-14	R-03	kurzeme	42.6	14.7
2026-07-16 02:59:41	gps_ping	V-031	D-14	R-14	latgale	34	24.5
2026-07-16 02:59:41	gps_ping	V-026	D-30	R-02	kurzeme	43.6	14.9
2026-07-16 02:59:35	trip_start	V-037	D-10	R-04	vidzeme	51.2	33.3
2026-07-16 02:59:34	gps_ping	V-049	D-19	R-02	kurzeme	80	33.8
2026-07-16 02:59:33	refuel	V-033	D-30	R-01	kurzeme	0	27
2026-07-16 02:59:32	speeding	V-001	D-10	R-04	vidzeme	46.7	29.2
2026-07-16 02:59:30	gps_ping	V-014	D-05	R-13	latgale	39.3	38.4
2026-07-16 02:59:29	gps_ping	V-015	D-01	R-09	riga	73.2	25.7
2026-07-16 02:59:28	gps_ping	V-002	D-20	R-10	latgale	87.4	37.2