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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:42:02	gps_ping	V-021	D-10	R-15	riga	74.9	27.2
2026-07-16 00:41:54	gps_ping	V-027	D-25	R-05	riga	72.5	23.6
2026-07-16 00:41:51	idle	V-025	D-02	R-06	vidzeme	0	28.4
2026-07-16 00:41:49	gps_ping	V-041	D-05	R-09	riga	81	26.7
2026-07-16 00:41:48	refuel	V-049	D-05	R-04	vidzeme	0	35.8
2026-07-16 00:41:42	trip_start	V-037	D-12	R-01	kurzeme	71.4	28.7
2026-07-16 00:41:40	idle	V-008	D-27	R-01	kurzeme	0	23
2026-07-16 00:41:37	trip_start	V-049	D-16	R-03	kurzeme	67.3	31
2026-07-16 00:41:34	engine_fault	V-028	D-14	R-01	kurzeme	33.6	28.7
2026-07-16 00:41:29	gps_ping	V-017	D-25	R-05	riga	13.5	30.2
2026-07-16 00:41:26	gps_ping	V-035	D-22	R-05	riga	74.2	31.2
2026-07-16 00:41:25	harsh_braking	V-028	D-25	R-09	riga	77	25.9
2026-07-16 00:41:23	gps_ping	V-002	D-30	R-13	latgale	65.1	43.5
2026-07-16 00:41:23	gps_ping	V-036	D-14	R-15	riga	30.6	31
2026-07-16 00:41:23	trip_start	V-020	D-08	R-01	kurzeme	64.6	26.5
2026-07-16 00:41:17	trip_end	V-013	D-14	R-07	riga	58	12.4
2026-07-16 00:41:15	refuel	V-049	D-25	R-13	latgale	0	32.5
2026-07-16 00:41:14	idle	V-018	D-12	R-10	latgale	0	11.7
2026-07-16 00:41:13	gps_ping	V-045	D-12	R-03	kurzeme	36.4	11.4
2026-07-16 00:41:06	gps_ping	V-036	D-04	R-11	vidzeme	41.4	28.8
2026-07-16 00:41:05	gps_ping	V-028	D-14	R-14	latgale	46.2	35.1
2026-07-16 00:41:04	gps_ping	V-047	D-11	R-08	latgale	75.8	14.9
2026-07-16 00:40:58	gps_ping	V-014	D-18	R-02	kurzeme	31	38.6
2026-07-16 00:40:58	trip_end	V-003	D-18	R-09	riga	66.8	28
2026-07-16 00:40:57	gps_ping	V-021	D-05	R-06	vidzeme	98.8	34.8
2026-07-16 00:40:57	gps_ping	V-014	D-20	R-03	kurzeme	35.2	29.7
2026-07-16 00:40:52	gps_ping	V-017	D-23	R-02	kurzeme	28.3	30.8
2026-07-16 00:40:50	refuel	V-013	D-28	R-12	kurzeme	0	9.8
2026-07-16 00:40:46	gps_ping	V-005	D-29	R-09	riga	72.1	13.7
2026-07-16 00:40:46	gps_ping	V-036	D-27	R-05	riga	86.1	26.1
2026-07-16 00:40:45	gps_ping	V-048	D-02	R-07	riga	35.6	32.6
2026-07-16 00:40:43	trip_start	V-041	D-11	R-03	kurzeme	83.3	27.4
2026-07-16 00:40:42	trip_end	V-009	D-01	R-01	kurzeme	38.4	32
2026-07-16 00:40:41	gps_ping	V-014	D-06	R-06	vidzeme	73.9	27.3
2026-07-16 00:40:40	gps_ping	V-026	D-02	R-09	riga	80.6	15.4
2026-07-16 00:40:39	gps_ping	V-045	D-12	R-07	riga	78	11.2
2026-07-16 00:40:36	trip_end	V-034	D-14	R-11	vidzeme	73.9	21.7
2026-07-16 00:40:31	trip_end	V-037	D-20	R-11	vidzeme	43.6	36.7
2026-07-16 00:40:29	gps_ping	V-029	D-25	R-10	latgale	50.9	31
2026-07-16 00:40:27	harsh_braking	V-015	D-20	R-12	kurzeme	37	26.8
2026-07-16 00:40:22	gps_ping	V-015	D-20	R-10	latgale	53.4	24
2026-07-16 00:40:16	gps_ping	V-030	D-24	R-09	riga	31.6	12.7
2026-07-16 00:40:14	gps_ping	V-009	D-25	R-11	vidzeme	92.2	31.5
2026-07-16 00:40:14	gps_ping	V-027	D-19	R-12	kurzeme	61.5	30.6
2026-07-16 00:40:13	harsh_braking	V-043	D-02	R-15	riga	46	26.9
2026-07-16 00:40:08	speeding	V-020	D-19	R-14	latgale	63.6	27
2026-07-16 00:40:08	gps_ping	V-031	D-08	R-08	latgale	35.6	28
2026-07-16 00:40:04	harsh_braking	V-031	D-21	R-08	latgale	81.8	26.7
2026-07-16 00:40:04	gps_ping	V-013	D-11	R-05	riga	70.3	13.3
2026-07-16 00:40:01	harsh_braking	V-016	D-26	R-02	kurzeme	68.3	38