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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:58:25	gps_ping	V-033	D-20	R-01	kurzeme	36.3	19.5
2026-07-16 01:58:25	gps_ping	V-023	D-14	R-10	latgale	68.2	43.8
2026-07-16 01:58:22	gps_ping	V-040	D-09	R-12	kurzeme	69.4	34.9
2026-07-16 01:58:21	gps_ping	V-014	D-14	R-04	vidzeme	31.3	47
2026-07-16 01:58:21	gps_ping	V-040	D-19	R-02	kurzeme	45.7	32.5
2026-07-16 01:58:17	gps_ping	V-005	D-01	R-07	riga	38.1	15.4
2026-07-16 01:58:13	gps_ping	V-023	D-30	R-15	riga	69.8	29.5
2026-07-16 01:58:10	gps_ping	V-020	D-10	R-01	kurzeme	49.3	30.5
2026-07-16 01:58:08	gps_ping	V-009	D-29	R-12	kurzeme	65.4	31.2
2026-07-16 01:58:06	gps_ping	V-034	D-16	R-02	kurzeme	54.5	24.2
2026-07-16 01:58:05	gps_ping	V-012	D-22	R-08	latgale	57.7	33
2026-07-16 01:58:03	gps_ping	V-032	D-13	R-06	vidzeme	71.7	12
2026-07-16 01:58:00	gps_ping	V-008	D-30	R-15	riga	19.6	27.1
2026-07-16 01:57:55	gps_ping	V-044	D-08	R-15	riga	36.3	33.4
2026-07-16 01:57:46	idle	V-012	D-07	R-02	kurzeme	0	29.6
2026-07-16 01:57:40	harsh_braking	V-046	D-08	R-13	latgale	39	27.3
2026-07-16 01:57:38	gps_ping	V-003	D-04	R-11	vidzeme	31.3	23.8
2026-07-16 01:57:35	speeding	V-031	D-11	R-01	kurzeme	42.3	27.3
2026-07-16 01:57:29	gps_ping	V-029	D-18	R-10	latgale	52.5	27.7
2026-07-16 01:57:28	gps_ping	V-033	D-29	R-15	riga	61.3	22.3
2026-07-16 01:57:28	gps_ping	V-037	D-25	R-09	riga	57.8	33.6
2026-07-16 01:57:24	gps_ping	V-030	D-24	R-15	riga	81.7	14.7
2026-07-16 01:57:21	engine_fault	V-007	D-25	R-15	riga	77	10.5
2026-07-16 01:57:21	gps_ping	V-035	D-27	R-04	vidzeme	23.8	33
2026-07-16 01:57:16	gps_ping	V-050	D-06	R-08	latgale	51.3	26.9
2026-07-16 01:57:13	gps_ping	V-013	D-27	R-07	riga	74.3	14
2026-07-16 01:57:12	trip_end	V-042	D-26	R-02	kurzeme	76	32.3
2026-07-16 01:57:12	gps_ping	V-038	D-03	R-02	kurzeme	14.5	28.6
2026-07-16 01:57:10	gps_ping	V-032	D-28	R-02	kurzeme	32.7	13.6
2026-07-16 01:57:05	gps_ping	V-026	D-26	R-15	riga	84.5	11.4
2026-07-16 01:57:05	trip_end	V-006	D-13	R-02	kurzeme	84.1	27.5
2026-07-16 01:56:59	trip_start	V-018	D-22	R-06	vidzeme	62.6	13.1
2026-07-16 01:56:56	gps_ping	V-020	D-01	R-05	riga	46.1	26.2
2026-07-16 01:56:54	trip_end	V-010	D-07	R-15	riga	65.6	27.7
2026-07-16 01:56:50	trip_start	V-042	D-22	R-02	kurzeme	85.1	34.5
2026-07-16 01:56:49	gps_ping	V-003	D-07	R-01	kurzeme	76.7	30.5
2026-07-16 01:56:47	refuel	V-046	D-07	R-02	kurzeme	0	26.2
2026-07-16 01:56:41	trip_end	V-040	D-14	R-13	latgale	64.3	33.3
2026-07-16 01:56:38	gps_ping	V-032	D-19	R-09	riga	66.3	11.4
2026-07-16 01:56:38	speeding	V-021	D-02	R-11	vidzeme	34.1	38.7
2026-07-16 01:56:35	trip_end	V-026	D-11	R-01	kurzeme	69.1	9.3
2026-07-16 01:56:34	gps_ping	V-039	D-12	R-03	kurzeme	49.4	13.8
2026-07-16 01:56:33	gps_ping	V-015	D-11	R-02	kurzeme	78.7	25.8
2026-07-16 01:56:33	refuel	V-013	D-10	R-12	kurzeme	0	8.5
2026-07-16 01:56:33	gps_ping	V-040	D-16	R-15	riga	85.7	29.3
2026-07-16 01:56:32	harsh_braking	V-012	D-10	R-05	riga	54	31.5
2026-07-16 01:56:29	gps_ping	V-050	D-14	R-13	latgale	26.3	29.7
2026-07-16 01:56:29	trip_start	V-024	D-05	R-11	vidzeme	72.9	19.6
2026-07-16 01:56:25	gps_ping	V-009	D-25	R-07	riga	55.3	27.3
2026-07-16 01:56:20	gps_ping	V-040	D-01	R-11	vidzeme	59	33.7