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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:05:27	gps_ping	V-012	D-22	R-09	riga	61.3	29.1
2026-07-16 02:05:25	speeding	V-025	D-20	R-09	riga	69.5	26
2026-07-16 02:05:22	trip_end	V-006	D-29	R-05	riga	35.6	25.9
2026-07-16 02:05:22	gps_ping	V-035	D-09	R-13	latgale	37.2	34.8
2026-07-16 02:05:21	harsh_braking	V-016	D-29	R-06	vidzeme	29.5	33.9
2026-07-16 02:05:19	trip_start	V-048	D-27	R-11	vidzeme	57.2	29.2
2026-07-16 02:05:14	refuel	V-045	D-06	R-14	latgale	0	11.9
2026-07-16 02:05:13	gps_ping	V-049	D-09	R-08	latgale	78.8	33.7
2026-07-16 02:05:12	gps_ping	V-003	D-08	R-01	kurzeme	80.7	29.8
2026-07-16 02:05:11	harsh_braking	V-027	D-24	R-05	riga	54.2	33
2026-07-16 02:05:10	gps_ping	V-028	D-07	R-04	vidzeme	26.1	33.9
2026-07-16 02:05:09	refuel	V-050	D-14	R-01	kurzeme	0	20.3
2026-07-16 02:05:08	engine_fault	V-007	D-17	R-05	riga	82.4	11.9
2026-07-16 02:05:07	refuel	V-016	D-27	R-09	riga	0	39.4
2026-07-16 02:05:07	gps_ping	V-048	D-11	R-05	riga	68.8	25.8
2026-07-16 02:05:03	trip_start	V-017	D-01	R-14	latgale	70.2	28.6
2026-07-16 02:04:59	gps_ping	V-037	D-19	R-05	riga	33.9	34.5
2026-07-16 02:04:58	gps_ping	V-001	D-13	R-02	kurzeme	64.8	36.8
2026-07-16 02:04:57	gps_ping	V-029	D-06	R-05	riga	83.8	27.1
2026-07-16 02:04:54	trip_start	V-035	D-15	R-03	kurzeme	77.1	27.5
2026-07-16 02:04:42	gps_ping	V-047	D-06	R-10	latgale	64.4	10.6
2026-07-16 02:04:37	gps_ping	V-039	D-17	R-03	kurzeme	32.7	11.9
2026-07-16 02:04:35	gps_ping	V-025	D-19	R-09	riga	70	24.6
2026-07-16 02:04:29	gps_ping	V-041	D-17	R-12	kurzeme	86.3	29.7
2026-07-16 02:04:17	refuel	V-021	D-29	R-13	latgale	0	30.7
2026-07-16 02:04:13	gps_ping	V-028	D-30	R-02	kurzeme	81.6	35.2
2026-07-16 02:04:12	gps_ping	V-015	D-21	R-14	latgale	39.8	29.3
2026-07-16 02:04:10	trip_start	V-046	D-15	R-11	vidzeme	52.4	22
2026-07-16 02:04:10	trip_end	V-023	D-02	R-10	latgale	64.5	31.2
2026-07-16 02:04:07	gps_ping	V-005	D-24	R-15	riga	30.6	11.7
2026-07-16 02:04:05	trip_end	V-004	D-22	R-15	riga	66.6	31.1
2026-07-16 02:04:05	gps_ping	V-028	D-04	R-13	latgale	51.1	36.3
2026-07-16 02:04:05	gps_ping	V-009	D-17	R-12	kurzeme	33.9	37.2
2026-07-16 02:04:00	gps_ping	V-015	D-17	R-03	kurzeme	78.8	33.7
2026-07-16 02:03:49	trip_end	V-006	D-14	R-09	riga	51.3	32.4
2026-07-16 02:03:43	harsh_braking	V-036	D-29	R-01	kurzeme	46.8	28.8
2026-07-16 02:03:41	trip_end	V-002	D-09	R-14	latgale	92.2	33.2
2026-07-16 02:03:41	gps_ping	V-032	D-21	R-01	kurzeme	50.6	14.4
2026-07-16 02:03:39	idle	V-036	D-07	R-02	kurzeme	0	30.4
2026-07-16 02:03:38	harsh_braking	V-035	D-10	R-13	latgale	94.6	31.7
2026-07-16 02:03:36	gps_ping	V-030	D-06	R-13	latgale	62.1	15.7
2026-07-16 02:03:35	trip_start	V-002	D-21	R-08	latgale	29	33.2
2026-07-16 02:03:25	gps_ping	V-026	D-11	R-12	kurzeme	24.9	12.2
2026-07-16 02:03:22	gps_ping	V-038	D-07	R-15	riga	33.9	37.8
2026-07-16 02:03:21	gps_ping	V-016	D-18	R-15	riga	94.1	32.6
2026-07-16 02:03:19	gps_ping	V-049	D-22	R-09	riga	57.3	34.3
2026-07-16 02:03:19	speeding	V-003	D-03	R-04	vidzeme	35.4	36.3
2026-07-16 02:03:16	speeding	V-041	D-05	R-15	riga	33.2	27.3
2026-07-16 02:03:15	gps_ping	V-014	D-08	R-02	kurzeme	83.7	31.1
2026-07-16 02:03:14	engine_fault	V-023	D-08	R-08	latgale	55.4	40.5