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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:31:58	gps_ping	V-050	D-24	R-04	vidzeme	48	26.1
2026-07-16 02:31:58	gps_ping	V-010	D-24	R-15	riga	83.2	27
2026-07-16 02:31:57	gps_ping	V-043	D-16	R-13	latgale	55.3	27.5
2026-07-16 02:31:56	gps_ping	V-044	D-07	R-09	riga	79.2	21.9
2026-07-16 02:31:55	gps_ping	V-004	D-03	R-14	latgale	59.4	28.7
2026-07-16 02:31:55	speeding	V-035	D-09	R-14	latgale	28.9	36.4
2026-07-16 02:31:51	gps_ping	V-020	D-24	R-02	kurzeme	59.3	28.3
2026-07-16 02:31:46	trip_end	V-014	D-20	R-13	latgale	30.5	30.9
2026-07-16 02:31:41	trip_end	V-039	D-05	R-02	kurzeme	59.9	15
2026-07-16 02:31:41	gps_ping	V-005	D-21	R-07	riga	42.1	17.3
2026-07-16 02:31:35	gps_ping	V-008	D-04	R-12	kurzeme	52.5	28.5
2026-07-16 02:31:34	gps_ping	V-029	D-12	R-10	latgale	26.2	29.5
2026-07-16 02:31:33	refuel	V-006	D-04	R-13	latgale	0	29
2026-07-16 02:31:32	trip_end	V-046	D-20	R-06	vidzeme	56.3	29
2026-07-16 02:31:30	gps_ping	V-024	D-06	R-11	vidzeme	41.5	13.1
2026-07-16 02:31:28	idle	V-049	D-30	R-01	kurzeme	0	32.3
2026-07-16 02:31:28	gps_ping	V-002	D-05	R-03	kurzeme	42.2	37
2026-07-16 02:31:24	gps_ping	V-035	D-06	R-01	kurzeme	71.5	31.7
2026-07-16 02:31:21	refuel	V-045	D-06	R-01	kurzeme	0	15.9
2026-07-16 02:31:18	gps_ping	V-024	D-09	R-05	riga	56	14.3
2026-07-16 02:31:16	engine_fault	V-001	D-12	R-12	kurzeme	43.7	41.6
2026-07-16 02:31:14	gps_ping	V-024	D-30	R-10	latgale	39	12.8
2026-07-16 02:31:12	gps_ping	V-047	D-23	R-13	latgale	40.7	12.5
2026-07-16 02:31:12	gps_ping	V-017	D-29	R-03	kurzeme	86	30.2
2026-07-16 02:30:57	gps_ping	V-017	D-02	R-15	riga	20.8	29.6
2026-07-16 02:30:54	refuel	V-044	D-07	R-12	kurzeme	0	29.8
2026-07-16 02:30:52	trip_start	V-041	D-29	R-05	riga	69.1	30.6
2026-07-16 02:30:49	gps_ping	V-003	D-11	R-07	riga	21.7	28.5
2026-07-16 02:30:48	engine_fault	V-006	D-04	R-11	vidzeme	84.8	27.1
2026-07-16 02:30:47	trip_end	V-025	D-02	R-09	riga	34.4	32.3
2026-07-16 02:30:45	gps_ping	V-015	D-05	R-11	vidzeme	76.9	25.4
2026-07-16 02:30:45	gps_ping	V-008	D-11	R-04	vidzeme	36.6	30.1
2026-07-16 02:30:44	gps_ping	V-003	D-15	R-09	riga	61.6	20.4
2026-07-16 02:30:42	gps_ping	V-014	D-08	R-10	latgale	60.7	35.3
2026-07-16 02:30:34	gps_ping	V-049	D-12	R-14	latgale	79.1	36.3
2026-07-16 02:30:23	gps_ping	V-047	D-04	R-10	latgale	62.9	15.6
2026-07-16 02:30:23	gps_ping	V-037	D-06	R-10	latgale	51.1	36.3
2026-07-16 02:30:21	gps_ping	V-026	D-09	R-10	latgale	60.2	15.8
2026-07-16 02:30:20	gps_ping	V-016	D-16	R-04	vidzeme	38.7	36.7
2026-07-16 02:30:20	trip_end	V-014	D-07	R-07	riga	61.2	41.1
2026-07-16 02:30:20	gps_ping	V-023	D-26	R-05	riga	40.1	31.8
2026-07-16 02:30:18	gps_ping	V-041	D-22	R-06	vidzeme	33.7	27.5
2026-07-16 02:30:11	gps_ping	V-046	D-20	R-04	vidzeme	37.2	25.3
2026-07-16 02:30:10	gps_ping	V-029	D-26	R-06	vidzeme	80.2	29.4
2026-07-16 02:30:10	gps_ping	V-014	D-20	R-14	latgale	86.9	33.7
2026-07-16 02:30:04	gps_ping	V-016	D-22	R-03	kurzeme	24.6	32.9
2026-07-16 02:30:02	trip_end	V-017	D-02	R-10	latgale	44.6	25.6
2026-07-16 02:29:59	refuel	V-046	D-10	R-13	latgale	0	28.6
2026-07-16 02:29:52	gps_ping	V-022	D-20	R-15	riga	66.4	27.5
2026-07-16 02:29:52	engine_fault	V-031	D-16	R-06	vidzeme	22.8	24.2