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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 02:59:17	gps_ping	V-047	D-10	R-06	vidzeme	83	16.7
2026-07-16 02:59:14	gps_ping	V-027	D-04	R-11	vidzeme	39.5	26.1
2026-07-16 02:59:09	gps_ping	V-001	D-21	R-13	latgale	73.5	22.1
2026-07-16 02:59:04	speeding	V-038	D-28	R-06	vidzeme	50.7	23.8
2026-07-16 02:59:02	gps_ping	V-048	D-11	R-06	vidzeme	59.9	28
2026-07-16 02:58:58	gps_ping	V-010	D-19	R-05	riga	87.8	36
2026-07-16 02:58:58	gps_ping	V-024	D-22	R-08	latgale	47.1	9.9
2026-07-16 02:58:52	gps_ping	V-024	D-19	R-12	kurzeme	50.3	14.9
2026-07-16 02:58:49	trip_start	V-006	D-16	R-05	riga	44.6	27.2
2026-07-16 02:58:46	refuel	V-047	D-01	R-07	riga	0	13.1
2026-07-16 02:58:45	harsh_braking	V-012	D-21	R-12	kurzeme	23.1	29.6
2026-07-16 02:58:41	trip_start	V-026	D-01	R-14	latgale	51.6	15.5
2026-07-16 02:58:39	gps_ping	V-032	D-07	R-07	riga	88.6	14.9
2026-07-16 02:58:38	refuel	V-041	D-23	R-02	kurzeme	0	25.5
2026-07-16 02:58:30	trip_start	V-016	D-27	R-05	riga	31.7	31.1
2026-07-16 02:58:24	trip_start	V-012	D-28	R-03	kurzeme	22.5	28.7
2026-07-16 02:58:24	gps_ping	V-030	D-06	R-05	riga	62.3	11.9
2026-07-16 02:58:23	trip_end	V-024	D-19	R-02	kurzeme	67.8	13.8
2026-07-16 02:58:23	trip_start	V-045	D-15	R-05	riga	81.4	13.4
2026-07-16 02:58:21	gps_ping	V-037	D-03	R-01	kurzeme	54.9	29.5
2026-07-16 02:58:18	gps_ping	V-048	D-14	R-15	riga	48.9	29.6
2026-07-16 02:58:14	refuel	V-033	D-26	R-09	riga	0	32.4
2026-07-16 02:58:13	gps_ping	V-026	D-03	R-01	kurzeme	40.8	14.2
2026-07-16 02:58:13	gps_ping	V-020	D-29	R-07	riga	108.6	27.4
2026-07-16 02:58:09	gps_ping	V-034	D-22	R-07	riga	36.6	39.1
2026-07-16 02:58:06	gps_ping	V-035	D-16	R-02	kurzeme	80.4	31.9
2026-07-16 02:58:05	refuel	V-026	D-07	R-07	riga	0	15.2
2026-07-16 02:57:58	gps_ping	V-044	D-28	R-15	riga	84.3	32.7
2026-07-16 02:57:52	trip_start	V-045	D-13	R-03	kurzeme	82.6	17.4
2026-07-16 02:57:49	gps_ping	V-022	D-25	R-15	riga	42.8	28.3
2026-07-16 02:57:43	gps_ping	V-008	D-01	R-14	latgale	70.2	28.6
2026-07-16 02:57:41	gps_ping	V-005	D-11	R-13	latgale	51.5	15
2026-07-16 02:57:40	trip_start	V-003	D-18	R-03	kurzeme	35.9	26.4
2026-07-16 02:57:36	gps_ping	V-044	D-19	R-09	riga	18.4	30.5
2026-07-16 02:57:34	trip_start	V-008	D-06	R-13	latgale	69.4	34.6
2026-07-16 02:57:32	gps_ping	V-002	D-03	R-04	vidzeme	28.5	30.6
2026-07-16 02:57:32	gps_ping	V-004	D-03	R-07	riga	37.2	29.7
2026-07-16 02:57:32	trip_end	V-028	D-01	R-04	vidzeme	59.9	29
2026-07-16 02:57:30	gps_ping	V-039	D-30	R-13	latgale	73.5	15.4
2026-07-16 02:57:28	gps_ping	V-047	D-08	R-09	riga	49.6	14.4
2026-07-16 02:57:28	gps_ping	V-050	D-21	R-01	kurzeme	81.4	35.3
2026-07-16 02:57:27	gps_ping	V-004	D-20	R-11	vidzeme	40.7	27
2026-07-16 02:57:16	gps_ping	V-020	D-22	R-03	kurzeme	61.4	31.8
2026-07-16 02:57:14	idle	V-032	D-05	R-08	latgale	0	11.7
2026-07-16 02:57:12	gps_ping	V-037	D-06	R-11	vidzeme	86.9	27.5
2026-07-16 02:57:10	harsh_braking	V-021	D-07	R-05	riga	17.4	36.7
2026-07-16 02:57:10	harsh_braking	V-029	D-13	R-13	latgale	101.7	23.8
2026-07-16 02:57:06	gps_ping	V-019	D-03	R-12	kurzeme	77.9	35.7
2026-07-16 02:56:59	gps_ping	V-028	D-15	R-12	kurzeme	46.7	38.9
2026-07-16 02:56:59	gps_ping	V-031	D-01	R-09	riga	71.7	27.9