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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:15:48	trip_end	V-039	D-27	R-10	latgale	30.8	14.6
2026-07-16 02:15:46	idle	V-042	D-29	R-06	vidzeme	0	29.3
2026-07-16 02:15:46	gps_ping	V-028	D-03	R-15	riga	56.9	34.8
2026-07-16 02:15:45	gps_ping	V-019	D-26	R-02	kurzeme	76.2	30.2
2026-07-16 02:15:45	trip_end	V-016	D-22	R-04	vidzeme	35.5	34.5
2026-07-16 02:15:42	gps_ping	V-018	D-29	R-12	kurzeme	80	14.4
2026-07-16 02:15:37	gps_ping	V-029	D-06	R-14	latgale	46.7	27.3
2026-07-16 02:15:37	trip_start	V-037	D-17	R-09	riga	49.9	27.5
2026-07-16 02:15:36	refuel	V-014	D-05	R-03	kurzeme	0	34.2
2026-07-16 02:15:35	speeding	V-019	D-03	R-14	latgale	40.9	26.8
2026-07-16 02:15:34	gps_ping	V-023	D-11	R-01	kurzeme	20.5	39
2026-07-16 02:15:31	refuel	V-010	D-23	R-14	latgale	0	27.2
2026-07-16 02:15:27	speeding	V-048	D-11	R-06	vidzeme	49.2	31.9
2026-07-16 02:15:26	trip_start	V-026	D-22	R-15	riga	53.2	15.9
2026-07-16 02:15:25	refuel	V-004	D-30	R-09	riga	0	29.7
2026-07-16 02:15:22	gps_ping	V-040	D-15	R-06	vidzeme	51.8	36.3
2026-07-16 02:15:22	harsh_braking	V-030	D-14	R-09	riga	79.3	16.4
2026-07-16 02:15:19	speeding	V-046	D-01	R-05	riga	58	31.9
2026-07-16 02:15:18	gps_ping	V-019	D-18	R-14	latgale	53	31.1
2026-07-16 02:15:16	speeding	V-049	D-14	R-15	riga	78	31.9
2026-07-16 02:15:15	gps_ping	V-040	D-13	R-07	riga	84.9	28.9
2026-07-16 02:15:14	gps_ping	V-009	D-16	R-11	vidzeme	99.5	30.4
2026-07-16 02:15:13	gps_ping	V-040	D-21	R-05	riga	68.3	24.4
2026-07-16 02:15:12	gps_ping	V-047	D-01	R-14	latgale	75.6	10.4
2026-07-16 02:15:11	gps_ping	V-046	D-08	R-10	latgale	56.9	20.7
2026-07-16 02:15:10	trip_start	V-041	D-08	R-13	latgale	52.6	24.8
2026-07-16 02:15:09	gps_ping	V-015	D-08	R-09	riga	26	30
2026-07-16 02:15:06	gps_ping	V-040	D-05	R-09	riga	79.2	31.7
2026-07-16 02:15:05	gps_ping	V-048	D-08	R-11	vidzeme	56.7	29.4
2026-07-16 02:14:58	gps_ping	V-027	D-05	R-09	riga	51.9	32.7
2026-07-16 02:14:58	trip_end	V-018	D-14	R-13	latgale	92.7	14.2
2026-07-16 02:14:58	gps_ping	V-012	D-15	R-06	vidzeme	29.5	26.1
2026-07-16 02:14:55	trip_start	V-011	D-19	R-02	kurzeme	29.4	14.3
2026-07-16 02:14:54	gps_ping	V-015	D-05	R-05	riga	76.8	26.6
2026-07-16 02:14:53	trip_start	V-034	D-27	R-10	latgale	76.7	28.8
2026-07-16 02:14:46	trip_end	V-010	D-16	R-13	latgale	41.5	25.4
2026-07-16 02:14:41	gps_ping	V-043	D-27	R-10	latgale	29.1	28.2
2026-07-16 02:14:38	gps_ping	V-024	D-26	R-05	riga	61	12.1
2026-07-16 02:14:34	speeding	V-032	D-13	R-14	latgale	65.1	14.8
2026-07-16 02:14:31	trip_start	V-004	D-26	R-10	latgale	38.3	29.3
2026-07-16 02:14:27	engine_fault	V-048	D-04	R-07	riga	59.7	34.9
2026-07-16 02:14:25	gps_ping	V-046	D-28	R-09	riga	71.3	23.9
2026-07-16 02:14:23	speeding	V-017	D-15	R-11	vidzeme	69.8	26.6
2026-07-16 02:14:21	gps_ping	V-034	D-24	R-14	latgale	49.4	26.6
2026-07-16 02:14:21	harsh_braking	V-010	D-04	R-05	riga	50.3	24.4
2026-07-16 02:14:20	speeding	V-023	D-05	R-14	latgale	32.6	30
2026-07-16 02:14:17	gps_ping	V-039	D-14	R-08	latgale	58.5	10.4
2026-07-16 02:14:13	gps_ping	V-034	D-24	R-01	kurzeme	79.8	26
2026-07-16 02:14:08	trip_end	V-036	D-10	R-09	riga	53.7	25.1
2026-07-16 02:14:06	gps_ping	V-033	D-06	R-09	riga	90.9	26.6