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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:12:01	gps_ping	V-013	D-13	R-04	vidzeme	41.6	18.4
2026-07-16 02:11:59	trip_end	V-042	D-14	R-09	riga	52	32.3
2026-07-16 02:11:59	gps_ping	V-037	D-03	R-14	latgale	28.7	31.6
2026-07-16 02:11:57	gps_ping	V-039	D-17	R-07	riga	42.2	10.8
2026-07-16 02:11:55	gps_ping	V-012	D-27	R-10	latgale	24.2	29.2
2026-07-16 02:11:54	gps_ping	V-048	D-20	R-07	riga	73.2	24
2026-07-16 02:11:51	gps_ping	V-006	D-11	R-13	latgale	46.4	28.5
2026-07-16 02:11:50	speeding	V-026	D-08	R-02	kurzeme	61.4	13
2026-07-16 02:11:46	trip_end	V-024	D-20	R-08	latgale	49	14.3
2026-07-16 02:11:43	gps_ping	V-016	D-06	R-01	kurzeme	63	35.1
2026-07-16 02:11:43	gps_ping	V-046	D-02	R-09	riga	56.1	30.4
2026-07-16 02:11:42	speeding	V-025	D-11	R-05	riga	73.1	26.9
2026-07-16 02:11:40	gps_ping	V-018	D-24	R-08	latgale	40.6	14.9
2026-07-16 02:11:39	gps_ping	V-004	D-22	R-01	kurzeme	72.2	26.9
2026-07-16 02:11:38	gps_ping	V-038	D-06	R-06	vidzeme	29.3	26.8
2026-07-16 02:11:32	gps_ping	V-048	D-12	R-02	kurzeme	37.3	27.7
2026-07-16 02:11:30	gps_ping	V-021	D-20	R-14	latgale	80.6	33.1
2026-07-16 02:11:29	gps_ping	V-012	D-13	R-12	kurzeme	91.8	31.6
2026-07-16 02:11:26	engine_fault	V-018	D-01	R-05	riga	89.2	17.1
2026-07-16 02:11:25	gps_ping	V-017	D-19	R-03	kurzeme	45.9	28.7
2026-07-16 02:11:23	gps_ping	V-021	D-10	R-01	kurzeme	69.2	35.2
2026-07-16 02:11:23	speeding	V-003	D-24	R-09	riga	82.6	27.5
2026-07-16 02:11:16	gps_ping	V-041	D-19	R-13	latgale	35.1	23.4
2026-07-16 02:11:08	gps_ping	V-029	D-25	R-02	kurzeme	69.5	26.7
2026-07-16 02:10:59	trip_end	V-015	D-10	R-14	latgale	40.9	32.9
2026-07-16 02:10:59	gps_ping	V-015	D-09	R-15	riga	56.9	24.3
2026-07-16 02:10:56	gps_ping	V-041	D-25	R-10	latgale	84.9	28.2
2026-07-16 02:10:54	idle	V-022	D-03	R-10	latgale	0	27.2
2026-07-16 02:10:51	refuel	V-030	D-22	R-02	kurzeme	0	14.1
2026-07-16 02:10:51	refuel	V-038	D-06	R-08	latgale	0	33.2
2026-07-16 02:10:47	refuel	V-034	D-22	R-11	vidzeme	0	28
2026-07-16 02:10:41	gps_ping	V-046	D-27	R-08	latgale	33	28.2
2026-07-16 02:10:41	gps_ping	V-001	D-06	R-14	latgale	34.9	30.3
2026-07-16 02:10:35	gps_ping	V-006	D-10	R-02	kurzeme	39.2	31.9
2026-07-16 02:10:33	gps_ping	V-002	D-05	R-09	riga	90.9	35.1
2026-07-16 02:10:33	gps_ping	V-035	D-06	R-04	vidzeme	21.6	31.4
2026-07-16 02:10:32	trip_end	V-006	D-10	R-07	riga	74.2	38.2
2026-07-16 02:10:32	gps_ping	V-034	D-29	R-12	kurzeme	60.3	24.7
2026-07-16 02:10:29	gps_ping	V-018	D-01	R-13	latgale	28.6	18.9
2026-07-16 02:10:29	idle	V-036	D-02	R-13	latgale	0	22.3
2026-07-16 02:10:28	gps_ping	V-016	D-01	R-14	latgale	42.6	28.8
2026-07-16 02:10:25	gps_ping	V-021	D-22	R-02	kurzeme	20.9	36.1
2026-07-16 02:10:25	gps_ping	V-033	D-23	R-11	vidzeme	76.2	23.8
2026-07-16 02:10:25	gps_ping	V-014	D-23	R-05	riga	40.6	35.4
2026-07-16 02:10:18	gps_ping	V-037	D-06	R-12	kurzeme	63.2	32.7
2026-07-16 02:10:10	gps_ping	V-019	D-27	R-07	riga	80.1	27.7
2026-07-16 02:10:08	gps_ping	V-018	D-27	R-15	riga	50	18.7
2026-07-16 02:10:05	gps_ping	V-037	D-13	R-08	latgale	81.4	31.7
2026-07-16 02:09:55	refuel	V-012	D-23	R-13	latgale	0	30.3
2026-07-16 02:09:54	gps_ping	V-013	D-14	R-02	kurzeme	29.3	16.8