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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:53:24	gps_ping	V-038	D-26	R-08	latgale	39.3	29.3
2026-07-16 00:53:22	trip_end	V-031	D-11	R-10	latgale	37.9	31
2026-07-16 00:53:18	gps_ping	V-033	D-16	R-02	kurzeme	92.9	27.4
2026-07-16 00:53:18	trip_start	V-022	D-27	R-15	riga	41.2	31.2
2026-07-16 00:53:16	idle	V-003	D-25	R-08	latgale	0	27
2026-07-16 00:53:16	gps_ping	V-030	D-03	R-04	vidzeme	57.2	17.5
2026-07-16 00:53:14	gps_ping	V-027	D-30	R-08	latgale	64.3	32.1
2026-07-16 00:53:09	gps_ping	V-022	D-30	R-08	latgale	66.2	28.8
2026-07-16 00:53:09	gps_ping	V-019	D-18	R-13	latgale	24	31.2
2026-07-16 00:53:05	gps_ping	V-014	D-23	R-07	riga	32.4	32.9
2026-07-16 00:53:00	gps_ping	V-050	D-25	R-05	riga	27	27.7
2026-07-16 00:52:52	gps_ping	V-011	D-15	R-12	kurzeme	36.3	16.6
2026-07-16 00:52:49	gps_ping	V-041	D-15	R-15	riga	63.8	19.8
2026-07-16 00:52:49	refuel	V-023	D-17	R-01	kurzeme	0	33.5
2026-07-16 00:52:49	trip_end	V-011	D-11	R-15	riga	72	14.4
2026-07-16 00:52:41	idle	V-021	D-11	R-11	vidzeme	0	31.3
2026-07-16 00:52:40	speeding	V-013	D-10	R-05	riga	24.7	12.1
2026-07-16 00:52:38	gps_ping	V-038	D-20	R-07	riga	66.8	31.1
2026-07-16 00:52:38	harsh_braking	V-016	D-01	R-14	latgale	79.8	37
2026-07-16 00:52:37	harsh_braking	V-005	D-18	R-11	vidzeme	56.4	12.1
2026-07-16 00:52:32	gps_ping	V-046	D-10	R-12	kurzeme	62.7	31.2
2026-07-16 00:52:29	trip_end	V-014	D-17	R-11	vidzeme	34.6	31.8
2026-07-16 00:52:27	harsh_braking	V-017	D-04	R-02	kurzeme	78.3	27
2026-07-16 00:52:07	gps_ping	V-040	D-03	R-05	riga	33.6	37.2
2026-07-16 00:52:06	gps_ping	V-012	D-21	R-09	riga	46.4	27.3
2026-07-16 00:52:06	trip_start	V-006	D-30	R-11	vidzeme	45.6	29.9
2026-07-16 00:52:03	gps_ping	V-012	D-25	R-07	riga	59.5	29.7
2026-07-16 00:52:03	engine_fault	V-041	D-10	R-05	riga	76.8	28.6
2026-07-16 00:51:58	gps_ping	V-049	D-16	R-12	kurzeme	74.3	35.8
2026-07-16 00:51:56	engine_fault	V-033	D-26	R-06	vidzeme	61.4	23.9
2026-07-16 00:51:55	gps_ping	V-035	D-08	R-09	riga	62.6	48.5
2026-07-16 00:51:53	trip_end	V-045	D-20	R-08	latgale	53.7	10
2026-07-16 00:51:51	trip_end	V-050	D-27	R-03	kurzeme	55.8	34.9
2026-07-16 00:51:50	refuel	V-006	D-05	R-12	kurzeme	0	31.6
2026-07-16 00:51:50	gps_ping	V-027	D-28	R-03	kurzeme	70.9	33.7
2026-07-16 00:51:46	idle	V-019	D-21	R-01	kurzeme	0	31.8
2026-07-16 00:51:32	trip_start	V-010	D-25	R-14	latgale	81	33.8
2026-07-16 00:51:30	gps_ping	V-007	D-07	R-04	vidzeme	31.7	14
2026-07-16 00:51:29	gps_ping	V-024	D-12	R-04	vidzeme	22.3	16.9
2026-07-16 00:51:28	trip_start	V-045	D-01	R-06	vidzeme	66.7	20.3
2026-07-16 00:51:26	gps_ping	V-009	D-09	R-02	kurzeme	39.9	32.6
2026-07-16 00:51:25	gps_ping	V-026	D-20	R-04	vidzeme	50.9	14.6
2026-07-16 00:51:24	harsh_braking	V-011	D-09	R-07	riga	46.1	18
2026-07-16 00:51:22	gps_ping	V-001	D-05	R-05	riga	90.5	26.6
2026-07-16 00:51:15	trip_end	V-013	D-18	R-02	kurzeme	49.3	18.3
2026-07-16 00:51:14	gps_ping	V-008	D-04	R-10	latgale	65.6	26.7
2026-07-16 00:51:13	trip_end	V-037	D-11	R-12	kurzeme	57.8	36.7
2026-07-16 00:51:09	speeding	V-029	D-30	R-07	riga	53.4	35.2
2026-07-16 00:51:04	trip_end	V-050	D-28	R-06	vidzeme	69.7	27.2
2026-07-16 00:51:02	trip_end	V-032	D-08	R-04	vidzeme	26	12.7