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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 01:38:51	gps_ping	V-020	D-12	R-10	latgale	47.8	24.7
2026-07-16 01:38:47	speeding	V-029	D-22	R-05	riga	82.3	29.1
2026-07-16 01:38:45	gps_ping	V-017	D-28	R-14	latgale	58.8	27.4
2026-07-16 01:38:44	gps_ping	V-003	D-08	R-04	vidzeme	63.3	26.9
2026-07-16 01:38:42	gps_ping	V-020	D-04	R-14	latgale	66.7	35.5
2026-07-16 01:38:40	refuel	V-045	D-27	R-09	riga	0	14
2026-07-16 01:38:34	harsh_braking	V-041	D-29	R-03	kurzeme	75.2	35.6
2026-07-16 01:38:32	gps_ping	V-031	D-22	R-11	vidzeme	53.4	28
2026-07-16 01:38:26	gps_ping	V-030	D-21	R-11	vidzeme	35.6	12.5
2026-07-16 01:38:25	gps_ping	V-018	D-29	R-05	riga	83.2	15.8
2026-07-16 01:38:20	speeding	V-034	D-07	R-12	kurzeme	92.1	31.9
2026-07-16 01:38:16	gps_ping	V-002	D-23	R-08	latgale	76	34
2026-07-16 01:38:10	trip_end	V-011	D-30	R-05	riga	86.1	13.2
2026-07-16 01:38:09	refuel	V-012	D-05	R-09	riga	0	28.5
2026-07-16 01:38:05	gps_ping	V-034	D-02	R-15	riga	34.5	27.9
2026-07-16 01:38:05	gps_ping	V-015	D-20	R-02	kurzeme	28.7	23.2
2026-07-16 01:38:05	gps_ping	V-046	D-06	R-13	latgale	74.1	28.3
2026-07-16 01:38:05	engine_fault	V-028	D-26	R-14	latgale	34.8	40.9
2026-07-16 01:38:03	gps_ping	V-014	D-24	R-06	vidzeme	32.9	30.7
2026-07-16 01:38:02	speeding	V-043	D-27	R-14	latgale	58.1	31.7
2026-07-16 01:38:01	gps_ping	V-029	D-26	R-03	kurzeme	54.9	29.3
2026-07-16 01:37:58	idle	V-024	D-01	R-13	latgale	0	14.6
2026-07-16 01:37:57	gps_ping	V-020	D-09	R-01	kurzeme	35	35
2026-07-16 01:37:54	gps_ping	V-036	D-01	R-03	kurzeme	56.7	35
2026-07-16 01:37:49	gps_ping	V-027	D-30	R-15	riga	57	28.1
2026-07-16 01:37:48	gps_ping	V-005	D-29	R-01	kurzeme	71.4	14.1
2026-07-16 01:37:45	gps_ping	V-030	D-17	R-04	vidzeme	53.9	16.4
2026-07-16 01:37:44	gps_ping	V-016	D-07	R-15	riga	72.7	28.1
2026-07-16 01:37:42	gps_ping	V-040	D-07	R-11	vidzeme	43.1	33.7
2026-07-16 01:37:38	speeding	V-044	D-24	R-14	latgale	29.3	23.6
2026-07-16 01:37:34	gps_ping	V-011	D-24	R-14	latgale	24.2	15
2026-07-16 01:37:33	gps_ping	V-034	D-14	R-06	vidzeme	42.6	24.1
2026-07-16 01:37:27	gps_ping	V-046	D-20	R-15	riga	88.7	29.8
2026-07-16 01:37:24	idle	V-034	D-23	R-01	kurzeme	0	29.2
2026-07-16 01:37:24	gps_ping	V-015	D-23	R-07	riga	98.9	24.9
2026-07-16 01:37:23	gps_ping	V-009	D-25	R-13	latgale	58.9	33.4
2026-07-16 01:37:22	gps_ping	V-010	D-02	R-03	kurzeme	39.6	28.7
2026-07-16 01:37:21	gps_ping	V-050	D-10	R-07	riga	53.1	26.1
2026-07-16 01:37:16	gps_ping	V-016	D-10	R-07	riga	42	44.8
2026-07-16 01:37:16	gps_ping	V-008	D-09	R-15	riga	46.3	25.2
2026-07-16 01:37:11	gps_ping	V-036	D-29	R-11	vidzeme	84.2	29.4
2026-07-16 01:37:08	refuel	V-042	D-03	R-02	kurzeme	0	28.9
2026-07-16 01:37:06	gps_ping	V-008	D-04	R-02	kurzeme	87.5	29.5
2026-07-16 01:37:05	gps_ping	V-008	D-30	R-10	latgale	49.9	28.5
2026-07-16 01:37:05	gps_ping	V-030	D-03	R-10	latgale	45	12.6
2026-07-16 01:37:01	trip_start	V-016	D-09	R-11	vidzeme	46.8	30
2026-07-16 01:36:57	gps_ping	V-045	D-12	R-01	kurzeme	58.1	14.8
2026-07-16 01:36:54	gps_ping	V-047	D-25	R-09	riga	70.2	13.4
2026-07-16 01:36:50	gps_ping	V-030	D-14	R-06	vidzeme	82.7	17
2026-07-16 01:36:48	gps_ping	V-020	D-22	R-12	kurzeme	31.2	23.1