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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:36:45	gps_ping	V-050	D-08	R-12	kurzeme	57.7	29.4
2026-07-16 01:36:38	engine_fault	V-031	D-22	R-14	latgale	38	34.9
2026-07-16 01:36:38	harsh_braking	V-012	D-08	R-04	vidzeme	49.9	28.5
2026-07-16 01:36:34	gps_ping	V-037	D-09	R-11	vidzeme	26.7	27.5
2026-07-16 01:36:30	gps_ping	V-022	D-17	R-03	kurzeme	30.8	27.2
2026-07-16 01:36:29	idle	V-026	D-13	R-06	vidzeme	0	12
2026-07-16 01:36:22	trip_start	V-001	D-12	R-13	latgale	50.7	27.1
2026-07-16 01:36:18	gps_ping	V-005	D-24	R-06	vidzeme	41.3	14.8
2026-07-16 01:36:16	trip_start	V-002	D-04	R-06	vidzeme	58.8	31
2026-07-16 01:36:16	speeding	V-020	D-21	R-01	kurzeme	31.1	27.5
2026-07-16 01:36:10	gps_ping	V-025	D-18	R-03	kurzeme	48.6	35.1
2026-07-16 01:36:08	harsh_braking	V-019	D-06	R-02	kurzeme	27.1	27.5
2026-07-16 01:36:07	trip_start	V-043	D-03	R-08	latgale	35.1	29.1
2026-07-16 01:36:06	refuel	V-017	D-29	R-15	riga	0	29.8
2026-07-16 01:36:03	idle	V-043	D-15	R-04	vidzeme	0	31.1
2026-07-16 01:35:56	refuel	V-008	D-28	R-09	riga	0	35.6
2026-07-16 01:35:53	harsh_braking	V-048	D-30	R-10	latgale	98.9	25.8
2026-07-16 01:35:53	trip_end	V-031	D-28	R-14	latgale	40.2	27.4
2026-07-16 01:35:52	gps_ping	V-031	D-03	R-09	riga	59.5	36.7
2026-07-16 01:35:37	gps_ping	V-041	D-15	R-13	latgale	84.3	29.6
2026-07-16 01:35:36	trip_end	V-008	D-16	R-02	kurzeme	12.3	24.2
2026-07-16 01:35:34	gps_ping	V-021	D-13	R-12	kurzeme	95.9	32.2
2026-07-16 01:35:31	gps_ping	V-038	D-29	R-09	riga	34.2	24.8
2026-07-16 01:35:24	trip_end	V-031	D-24	R-10	latgale	65.1	21.3
2026-07-16 01:35:23	idle	V-046	D-17	R-02	kurzeme	0	25.6
2026-07-16 01:35:21	gps_ping	V-003	D-11	R-11	vidzeme	59.8	31.3
2026-07-16 01:35:19	gps_ping	V-002	D-23	R-08	latgale	70.5	36.2
2026-07-16 01:35:19	gps_ping	V-004	D-12	R-04	vidzeme	25	24.5
2026-07-16 01:35:17	trip_start	V-009	D-27	R-12	kurzeme	67.8	38.4
2026-07-16 01:35:16	gps_ping	V-025	D-30	R-05	riga	73.4	27.7
2026-07-16 01:35:15	trip_end	V-049	D-16	R-14	latgale	31.6	33.9
2026-07-16 01:35:12	gps_ping	V-046	D-27	R-01	kurzeme	69.9	28.2
2026-07-16 01:35:12	harsh_braking	V-007	D-13	R-06	vidzeme	55.1	14.5
2026-07-16 01:35:09	gps_ping	V-042	D-28	R-08	latgale	63.6	31.6
2026-07-16 01:35:01	gps_ping	V-018	D-02	R-14	latgale	28.9	11.3
2026-07-16 01:34:59	gps_ping	V-038	D-07	R-15	riga	78.3	23.3
2026-07-16 01:34:51	harsh_braking	V-015	D-13	R-08	latgale	82.4	31.5
2026-07-16 01:34:50	engine_fault	V-034	D-28	R-11	vidzeme	35.6	29.9
2026-07-16 01:34:42	trip_end	V-017	D-18	R-14	latgale	34.6	39
2026-07-16 01:34:35	harsh_braking	V-040	D-05	R-04	vidzeme	34.9	33.1
2026-07-16 01:34:35	trip_end	V-017	D-20	R-13	latgale	73	28
2026-07-16 01:34:33	gps_ping	V-017	D-09	R-04	vidzeme	14.8	27.4
2026-07-16 01:34:32	gps_ping	V-014	D-18	R-07	riga	47.3	31.5
2026-07-16 01:34:30	trip_end	V-019	D-07	R-07	riga	30.4	28.3
2026-07-16 01:34:29	gps_ping	V-048	D-18	R-09	riga	24.4	30.8
2026-07-16 01:34:28	trip_end	V-024	D-22	R-03	kurzeme	73.6	12.4
2026-07-16 01:34:22	gps_ping	V-018	D-27	R-11	vidzeme	66.7	15.9
2026-07-16 01:34:22	trip_start	V-047	D-05	R-08	latgale	89.4	14.4
2026-07-16 01:34:20	trip_end	V-020	D-21	R-12	kurzeme	44.7	30.9
2026-07-16 01:34:09	gps_ping	V-030	D-20	R-13	latgale	90.2	18.3