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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:54:37	gps_ping	V-041	D-30	R-02	kurzeme	61.6	31.4
2026-07-16 01:54:35	idle	V-026	D-14	R-04	vidzeme	0	17.1
2026-07-16 01:54:34	gps_ping	V-009	D-21	R-01	kurzeme	50.9	31.3
2026-07-16 01:54:34	gps_ping	V-012	D-20	R-10	latgale	67.5	29
2026-07-16 01:54:32	idle	V-038	D-28	R-15	riga	0	27.3
2026-07-16 01:54:31	harsh_braking	V-035	D-16	R-03	kurzeme	79.9	29.3
2026-07-16 01:54:31	gps_ping	V-014	D-29	R-02	kurzeme	77	35.2
2026-07-16 01:54:28	gps_ping	V-025	D-18	R-14	latgale	37.9	30.7
2026-07-16 01:54:25	gps_ping	V-030	D-03	R-08	latgale	61.4	12.4
2026-07-16 01:54:22	gps_ping	V-014	D-07	R-10	latgale	56.5	33.5
2026-07-16 01:54:21	idle	V-006	D-22	R-02	kurzeme	0	31.9
2026-07-16 01:54:18	speeding	V-009	D-02	R-11	vidzeme	82	34.2
2026-07-16 01:54:16	gps_ping	V-010	D-05	R-07	riga	31.2	29.7
2026-07-16 01:54:15	gps_ping	V-007	D-08	R-06	vidzeme	51.2	16.1
2026-07-16 01:54:14	gps_ping	V-039	D-25	R-02	kurzeme	85.5	15.3
2026-07-16 01:54:11	gps_ping	V-039	D-19	R-15	riga	69.2	10.3
2026-07-16 01:54:10	gps_ping	V-030	D-15	R-07	riga	33.5	13.8
2026-07-16 01:54:09	trip_end	V-015	D-15	R-10	latgale	57.1	34.7
2026-07-16 01:54:06	gps_ping	V-047	D-17	R-12	kurzeme	39.3	13.1
2026-07-16 01:54:03	speeding	V-029	D-18	R-05	riga	20.3	29.4
2026-07-16 01:53:55	gps_ping	V-045	D-28	R-03	kurzeme	31.2	14.4
2026-07-16 01:53:44	gps_ping	V-026	D-29	R-15	riga	83.4	12.1
2026-07-16 01:53:42	refuel	V-048	D-03	R-12	kurzeme	0	29.1
2026-07-16 01:53:40	gps_ping	V-040	D-19	R-12	kurzeme	65.9	35
2026-07-16 01:53:38	gps_ping	V-004	D-07	R-01	kurzeme	51.6	29.2
2026-07-16 01:53:38	trip_end	V-038	D-07	R-02	kurzeme	74.5	35.3
2026-07-16 01:53:38	gps_ping	V-017	D-29	R-12	kurzeme	27.9	22.3
2026-07-16 01:53:32	trip_end	V-037	D-22	R-06	vidzeme	60.1	32.5
2026-07-16 01:53:29	trip_start	V-020	D-02	R-07	riga	63	27.6
2026-07-16 01:53:26	gps_ping	V-004	D-03	R-14	latgale	65.4	25.3
2026-07-16 01:53:26	harsh_braking	V-017	D-17	R-02	kurzeme	76.4	40.6
2026-07-16 01:53:25	gps_ping	V-037	D-19	R-03	kurzeme	48.2	34.7
2026-07-16 01:53:23	speeding	V-038	D-16	R-05	riga	41.2	28
2026-07-16 01:53:21	gps_ping	V-012	D-12	R-10	latgale	73	25.4
2026-07-16 01:53:16	idle	V-045	D-23	R-03	kurzeme	0	16.9
2026-07-16 01:53:10	gps_ping	V-041	D-15	R-13	latgale	66	23.5
2026-07-16 01:53:10	gps_ping	V-012	D-11	R-07	riga	46.8	30.3
2026-07-16 01:53:02	trip_end	V-026	D-07	R-01	kurzeme	23.2	14.1
2026-07-16 01:53:01	engine_fault	V-016	D-02	R-06	vidzeme	34.1	33.3
2026-07-16 01:52:59	trip_start	V-039	D-26	R-06	vidzeme	58.9	15.7
2026-07-16 01:52:52	gps_ping	V-018	D-06	R-10	latgale	71.4	13.6
2026-07-16 01:52:52	speeding	V-031	D-19	R-03	kurzeme	61.2	28.3
2026-07-16 01:52:50	trip_end	V-005	D-26	R-01	kurzeme	68.5	14.7
2026-07-16 01:52:46	gps_ping	V-026	D-07	R-12	kurzeme	79.6	15.3
2026-07-16 01:52:45	gps_ping	V-048	D-28	R-12	kurzeme	50.9	28.7
2026-07-16 01:52:43	speeding	V-010	D-03	R-08	latgale	79.8	21.8
2026-07-16 01:52:41	gps_ping	V-006	D-09	R-01	kurzeme	40.7	25.6
2026-07-16 01:52:34	gps_ping	V-026	D-21	R-08	latgale	40.9	13.3
2026-07-16 01:52:29	gps_ping	V-005	D-18	R-09	riga	46.3	13.6
2026-07-16 01:52:28	gps_ping	V-003	D-25	R-09	riga	66	23.6