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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:09:53	gps_ping	V-022	D-17	R-12	kurzeme	43.2	27.3
2026-07-16 02:09:49	gps_ping	V-027	D-10	R-15	riga	33.8	25.4
2026-07-16 02:09:46	engine_fault	V-015	D-10	R-05	riga	55.1	31
2026-07-16 02:09:39	trip_start	V-032	D-28	R-12	kurzeme	48	13.6
2026-07-16 02:09:30	gps_ping	V-046	D-12	R-14	latgale	83.6	27.9
2026-07-16 02:09:29	gps_ping	V-050	D-10	R-11	vidzeme	61.9	29.7
2026-07-16 02:09:25	refuel	V-029	D-06	R-12	kurzeme	0	28
2026-07-16 02:09:19	gps_ping	V-013	D-01	R-06	vidzeme	68.2	14.2
2026-07-16 02:09:15	gps_ping	V-030	D-22	R-09	riga	64.7	13.5
2026-07-16 02:09:14	refuel	V-001	D-12	R-11	vidzeme	0	30.3
2026-07-16 02:09:13	trip_end	V-025	D-14	R-06	vidzeme	70.7	25
2026-07-16 02:09:13	trip_end	V-012	D-10	R-13	latgale	36	31.9
2026-07-16 02:09:07	gps_ping	V-013	D-21	R-07	riga	87.6	15.8
2026-07-16 02:09:04	gps_ping	V-026	D-12	R-04	vidzeme	23.9	16.7
2026-07-16 02:09:01	engine_fault	V-030	D-16	R-01	kurzeme	87.3	14.5
2026-07-16 02:08:59	harsh_braking	V-031	D-12	R-04	vidzeme	70.1	26.7
2026-07-16 02:08:57	trip_start	V-004	D-15	R-08	latgale	53.1	28.7
2026-07-16 02:08:54	gps_ping	V-012	D-27	R-12	kurzeme	45.9	33.2
2026-07-16 02:08:49	gps_ping	V-046	D-26	R-15	riga	57.9	27.6
2026-07-16 02:08:48	gps_ping	V-022	D-24	R-02	kurzeme	24.5	28.8
2026-07-16 02:08:46	gps_ping	V-008	D-04	R-01	kurzeme	73.5	29.3
2026-07-16 02:08:45	gps_ping	V-004	D-22	R-09	riga	43.8	28.5
2026-07-16 02:08:45	gps_ping	V-014	D-25	R-06	vidzeme	92.1	25.6
2026-07-16 02:08:41	gps_ping	V-002	D-02	R-10	latgale	75.4	29.5
2026-07-16 02:08:40	refuel	V-004	D-21	R-09	riga	0	31.5
2026-07-16 02:08:39	gps_ping	V-013	D-14	R-12	kurzeme	89.7	20.2
2026-07-16 02:08:35	engine_fault	V-026	D-14	R-15	riga	53.1	14
2026-07-16 02:08:33	engine_fault	V-018	D-06	R-04	vidzeme	53.7	14.6
2026-07-16 02:08:32	trip_start	V-031	D-08	R-13	latgale	39.9	23.3
2026-07-16 02:08:29	gps_ping	V-010	D-20	R-15	riga	35.3	25.4
2026-07-16 02:08:28	gps_ping	V-038	D-06	R-02	kurzeme	37.5	23.4
2026-07-16 02:08:23	gps_ping	V-050	D-24	R-08	latgale	42.3	32.7
2026-07-16 02:08:22	trip_end	V-021	D-13	R-01	kurzeme	71.2	30
2026-07-16 02:08:20	gps_ping	V-024	D-12	R-05	riga	16.8	16.9
2026-07-16 02:08:19	trip_start	V-044	D-12	R-14	latgale	62.4	29.3
2026-07-16 02:08:11	gps_ping	V-010	D-09	R-02	kurzeme	33.3	25.4
2026-07-16 02:08:10	refuel	V-002	D-13	R-14	latgale	0	33.3
2026-07-16 02:08:08	gps_ping	V-044	D-10	R-08	latgale	17.9	32
2026-07-16 02:08:08	refuel	V-015	D-14	R-05	riga	0	28.4
2026-07-16 02:08:06	gps_ping	V-034	D-28	R-03	kurzeme	80.5	30.4
2026-07-16 02:07:58	gps_ping	V-023	D-07	R-02	kurzeme	97.7	40.8
2026-07-16 02:07:56	gps_ping	V-004	D-16	R-15	riga	20.8	35.9
2026-07-16 02:07:51	gps_ping	V-006	D-26	R-05	riga	70.3	33.2
2026-07-16 02:07:50	trip_start	V-031	D-25	R-09	riga	48.1	23.6
2026-07-16 02:07:48	gps_ping	V-010	D-01	R-11	vidzeme	72.3	28.7
2026-07-16 02:07:43	gps_ping	V-038	D-27	R-04	vidzeme	41.5	29.8
2026-07-16 02:07:42	gps_ping	V-028	D-22	R-15	riga	46.9	33.1
2026-07-16 02:07:40	gps_ping	V-017	D-02	R-12	kurzeme	73.7	24.1
2026-07-16 02:07:38	trip_start	V-038	D-16	R-03	kurzeme	78.6	26.5
2026-07-16 02:07:36	refuel	V-021	D-13	R-05	riga	0	30.9