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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:42:37	gps_ping	V-001	D-03	R-01	kurzeme	46.3	26.7
2026-07-16 02:42:35	gps_ping	V-047	D-17	R-02	kurzeme	34.2	21.4
2026-07-16 02:42:23	gps_ping	V-048	D-22	R-04	vidzeme	23.7	27.4
2026-07-16 02:42:18	gps_ping	V-032	D-06	R-10	latgale	80	16.7
2026-07-16 02:42:16	gps_ping	V-039	D-21	R-14	latgale	61.4	21.1
2026-07-16 02:42:14	gps_ping	V-017	D-16	R-15	riga	62.4	26.1
2026-07-16 02:42:13	gps_ping	V-006	D-16	R-05	riga	25.6	24
2026-07-16 02:42:10	gps_ping	V-007	D-02	R-10	latgale	27.9	13.4
2026-07-16 02:42:05	gps_ping	V-034	D-02	R-07	riga	67.1	31
2026-07-16 02:42:02	gps_ping	V-017	D-22	R-05	riga	53.3	38.6
2026-07-16 02:42:01	gps_ping	V-003	D-18	R-09	riga	59	29.5
2026-07-16 02:42:00	refuel	V-046	D-07	R-15	riga	0	28
2026-07-16 02:41:55	gps_ping	V-026	D-28	R-08	latgale	59.1	12.6
2026-07-16 02:41:46	gps_ping	V-031	D-04	R-02	kurzeme	42.8	26.5
2026-07-16 02:41:46	gps_ping	V-048	D-02	R-07	riga	76.6	24.3
2026-07-16 02:41:44	speeding	V-043	D-23	R-01	kurzeme	45.6	28.6
2026-07-16 02:41:40	refuel	V-039	D-30	R-03	kurzeme	0	13
2026-07-16 02:41:39	engine_fault	V-027	D-05	R-10	latgale	85.5	32.8
2026-07-16 02:41:37	trip_start	V-008	D-07	R-09	riga	52.4	28.1
2026-07-16 02:41:37	trip_end	V-019	D-13	R-04	vidzeme	23.9	30.1
2026-07-16 02:41:34	gps_ping	V-027	D-01	R-12	kurzeme	76.7	27.8
2026-07-16 02:41:34	gps_ping	V-027	D-19	R-03	kurzeme	72.9	29.7
2026-07-16 02:41:33	gps_ping	V-005	D-11	R-14	latgale	44.5	13.5
2026-07-16 02:41:32	refuel	V-048	D-23	R-05	riga	0	33.6
2026-07-16 02:41:29	trip_start	V-005	D-20	R-15	riga	68	13.2
2026-07-16 02:41:29	gps_ping	V-041	D-06	R-06	vidzeme	28.8	25.4
2026-07-16 02:41:25	refuel	V-032	D-30	R-06	vidzeme	0	13.1
2026-07-16 02:41:24	gps_ping	V-031	D-10	R-05	riga	90.1	27.5
2026-07-16 02:41:24	speeding	V-003	D-14	R-13	latgale	78.4	37.9
2026-07-16 02:41:21	gps_ping	V-011	D-26	R-05	riga	49.1	13.9
2026-07-16 02:41:18	gps_ping	V-009	D-18	R-01	kurzeme	89.3	36.9
2026-07-16 02:41:17	speeding	V-029	D-24	R-13	latgale	40.4	31.6
2026-07-16 02:41:16	gps_ping	V-009	D-20	R-03	kurzeme	72.1	34.5
2026-07-16 02:41:14	harsh_braking	V-029	D-26	R-08	latgale	45.9	24.6
2026-07-16 02:41:13	gps_ping	V-010	D-30	R-10	latgale	81.5	34.7
2026-07-16 02:41:13	trip_start	V-030	D-12	R-10	latgale	36	15
2026-07-16 02:41:12	harsh_braking	V-018	D-26	R-02	kurzeme	68.7	11.8
2026-07-16 02:41:10	gps_ping	V-025	D-27	R-06	vidzeme	93.7	27.4
2026-07-16 02:41:09	engine_fault	V-042	D-20	R-05	riga	38.9	27.1
2026-07-16 02:40:59	gps_ping	V-018	D-03	R-01	kurzeme	78.6	12.4
2026-07-16 02:40:56	gps_ping	V-024	D-24	R-06	vidzeme	30.6	12
2026-07-16 02:40:56	gps_ping	V-024	D-15	R-08	latgale	56.9	16.1
2026-07-16 02:40:54	gps_ping	V-020	D-24	R-10	latgale	96.9	26.4
2026-07-16 02:40:47	gps_ping	V-041	D-09	R-06	vidzeme	43.5	37.1
2026-07-16 02:40:45	speeding	V-029	D-20	R-14	latgale	37.1	27
2026-07-16 02:40:43	gps_ping	V-012	D-19	R-03	kurzeme	85.6	25.3
2026-07-16 02:40:39	gps_ping	V-001	D-10	R-04	vidzeme	31.8	31.7
2026-07-16 02:40:33	trip_start	V-042	D-08	R-09	riga	24.6	33.7
2026-07-16 02:40:30	refuel	V-004	D-03	R-14	latgale	0	24.5
2026-07-16 02:40:29	trip_start	V-040	D-10	R-06	vidzeme	81.7	32.8