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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:23:37	speeding	V-012	D-06	R-06	vidzeme	62.3	37.4
2026-07-16 02:23:34	refuel	V-003	D-21	R-05	riga	0	27.6
2026-07-16 02:23:31	gps_ping	V-036	D-30	R-01	kurzeme	46.6	28.7
2026-07-16 02:23:29	harsh_braking	V-027	D-25	R-11	vidzeme	79.2	27.9
2026-07-16 02:23:28	gps_ping	V-014	D-10	R-14	latgale	77.7	34.7
2026-07-16 02:23:27	gps_ping	V-006	D-07	R-14	latgale	34	27.6
2026-07-16 02:23:27	speeding	V-050	D-25	R-12	kurzeme	89.6	29.6
2026-07-16 02:23:24	gps_ping	V-043	D-03	R-12	kurzeme	65.5	19.9
2026-07-16 02:23:19	trip_end	V-044	D-27	R-04	vidzeme	35.5	29.8
2026-07-16 02:23:18	harsh_braking	V-027	D-25	R-14	latgale	38.4	30.3
2026-07-16 02:23:17	trip_end	V-035	D-30	R-02	kurzeme	46.4	37.6
2026-07-16 02:23:17	gps_ping	V-022	D-19	R-12	kurzeme	28.9	28
2026-07-16 02:23:14	engine_fault	V-041	D-28	R-14	latgale	71.7	30.5
2026-07-16 02:23:10	gps_ping	V-005	D-24	R-11	vidzeme	85.3	18.1
2026-07-16 02:23:07	gps_ping	V-025	D-15	R-15	riga	39.5	28.8
2026-07-16 02:23:04	gps_ping	V-011	D-15	R-07	riga	51.5	15.7
2026-07-16 02:23:02	gps_ping	V-036	D-20	R-06	vidzeme	76.3	30.3
2026-07-16 02:23:02	gps_ping	V-043	D-08	R-08	latgale	96.7	26.2
2026-07-16 02:23:01	speeding	V-009	D-24	R-02	kurzeme	57.4	32.9
2026-07-16 02:23:01	trip_start	V-012	D-17	R-08	latgale	67.2	29.5
2026-07-16 02:23:01	gps_ping	V-009	D-04	R-03	kurzeme	58.7	33.3
2026-07-16 02:23:00	gps_ping	V-030	D-08	R-11	vidzeme	59.3	12.7
2026-07-16 02:22:58	trip_end	V-001	D-06	R-02	kurzeme	45.5	27.8
2026-07-16 02:22:53	idle	V-014	D-25	R-04	vidzeme	0	31
2026-07-16 02:22:52	gps_ping	V-021	D-29	R-05	riga	44	36.3
2026-07-16 02:22:50	gps_ping	V-027	D-18	R-06	vidzeme	38.6	33.5
2026-07-16 02:22:42	gps_ping	V-043	D-23	R-06	vidzeme	38.4	31.8
2026-07-16 02:22:38	gps_ping	V-049	D-18	R-14	latgale	34.6	29.7
2026-07-16 02:22:36	refuel	V-017	D-05	R-10	latgale	0	27.6
2026-07-16 02:22:34	refuel	V-017	D-22	R-11	vidzeme	0	27.3
2026-07-16 02:22:33	idle	V-022	D-17	R-11	vidzeme	0	26.9
2026-07-16 02:22:32	gps_ping	V-038	D-28	R-02	kurzeme	40.4	27.4
2026-07-16 02:22:31	gps_ping	V-013	D-19	R-12	kurzeme	43.2	10.2
2026-07-16 02:22:31	gps_ping	V-017	D-09	R-11	vidzeme	43.6	28.7
2026-07-16 02:22:30	gps_ping	V-039	D-03	R-13	latgale	20	14.3
2026-07-16 02:22:27	gps_ping	V-045	D-15	R-03	kurzeme	69.7	14
2026-07-16 02:22:21	harsh_braking	V-016	D-21	R-08	latgale	36.1	27.6
2026-07-16 02:22:19	refuel	V-036	D-09	R-14	latgale	0	26.5
2026-07-16 02:22:11	trip_start	V-016	D-23	R-09	riga	80.2	38.2
2026-07-16 02:22:09	gps_ping	V-024	D-14	R-12	kurzeme	64	15
2026-07-16 02:22:05	gps_ping	V-011	D-28	R-03	kurzeme	84.1	15.4
2026-07-16 02:22:04	engine_fault	V-015	D-23	R-03	kurzeme	47.3	31.3
2026-07-16 02:22:04	gps_ping	V-011	D-05	R-02	kurzeme	74.9	18.2
2026-07-16 02:21:59	gps_ping	V-036	D-15	R-01	kurzeme	46.3	27.8
2026-07-16 02:21:49	gps_ping	V-040	D-17	R-11	vidzeme	74.2	33.1
2026-07-16 02:21:43	trip_end	V-045	D-18	R-07	riga	76.9	12.9
2026-07-16 02:21:42	gps_ping	V-002	D-17	R-04	vidzeme	21.9	30.7
2026-07-16 02:21:33	gps_ping	V-048	D-29	R-12	kurzeme	79.3	29.3
2026-07-16 02:21:27	refuel	V-040	D-02	R-01	kurzeme	0	27.5
2026-07-16 02:21:25	gps_ping	V-010	D-13	R-01	kurzeme	75.3	23.8