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

event_time	event_type	vehicle_id	driver_id	route_id	region	speed_kmh	fuel_consumption_l100
2026-07-16 00:37:30	gps_ping	V-045	D-15	R-06	vidzeme	70.5	15.5
2026-07-16 00:37:27	gps_ping	V-006	D-24	R-10	latgale	51.4	29.3
2026-07-16 00:37:24	refuel	V-026	D-25	R-08	latgale	0	15.3
2026-07-16 00:37:22	gps_ping	V-018	D-11	R-08	latgale	63.2	14.1
2026-07-16 00:37:19	gps_ping	V-017	D-06	R-10	latgale	34.3	29.4
2026-07-16 00:37:19	trip_end	V-004	D-24	R-12	kurzeme	64.5	27.1
2026-07-16 00:37:18	refuel	V-025	D-03	R-08	latgale	0	26.4
2026-07-16 00:37:17	trip_end	V-012	D-14	R-10	latgale	76	35.2
2026-07-16 00:37:15	gps_ping	V-003	D-14	R-13	latgale	89.9	28
2026-07-16 00:37:10	gps_ping	V-010	D-26	R-04	vidzeme	60	24.8
2026-07-16 00:37:09	gps_ping	V-020	D-16	R-13	latgale	48.6	30.9
2026-07-16 00:37:07	refuel	V-023	D-28	R-10	latgale	0	32.5
2026-07-16 00:37:06	gps_ping	V-020	D-27	R-15	riga	29	29.9
2026-07-16 00:37:04	gps_ping	V-050	D-29	R-13	latgale	34.5	26.5
2026-07-16 00:37:03	gps_ping	V-014	D-15	R-07	riga	60.4	33.6
2026-07-16 00:37:01	speeding	V-012	D-13	R-12	kurzeme	76.9	27.4
2026-07-16 00:36:58	gps_ping	V-028	D-01	R-07	riga	76.4	30.7
2026-07-16 00:36:53	gps_ping	V-040	D-16	R-02	kurzeme	26.1	26.3
2026-07-16 00:36:53	trip_end	V-024	D-27	R-03	kurzeme	39.8	14
2026-07-16 00:36:48	gps_ping	V-004	D-20	R-08	latgale	28.8	26.4
2026-07-16 00:36:47	idle	V-009	D-23	R-03	kurzeme	0	36.1
2026-07-16 00:36:46	engine_fault	V-006	D-15	R-06	vidzeme	70.7	26.6
2026-07-16 00:36:41	gps_ping	V-042	D-14	R-09	riga	40.4	33
2026-07-16 00:36:37	gps_ping	V-006	D-19	R-03	kurzeme	35.4	28.7
2026-07-16 00:36:36	refuel	V-047	D-28	R-05	riga	0	16
2026-07-16 00:36:27	gps_ping	V-050	D-08	R-03	kurzeme	57	39.2
2026-07-16 00:36:25	gps_ping	V-010	D-25	R-07	riga	68.5	27.9
2026-07-16 00:36:24	gps_ping	V-035	D-11	R-09	riga	39	35.1
2026-07-16 00:36:24	engine_fault	V-026	D-05	R-09	riga	68.9	14.3
2026-07-16 00:36:19	gps_ping	V-037	D-28	R-14	latgale	85.7	37.6
2026-07-16 00:36:18	harsh_braking	V-017	D-23	R-07	riga	52	29.5
2026-07-16 00:36:17	gps_ping	V-046	D-15	R-05	riga	41.9	24.5
2026-07-16 00:36:17	gps_ping	V-004	D-15	R-13	latgale	75.8	21.1
2026-07-16 00:36:16	gps_ping	V-028	D-12	R-01	kurzeme	62.9	30.4
2026-07-16 00:36:13	trip_start	V-024	D-10	R-15	riga	72	13.6
2026-07-16 00:36:11	gps_ping	V-005	D-20	R-02	kurzeme	45.3	16.6
2026-07-16 00:36:07	gps_ping	V-015	D-06	R-06	vidzeme	77.2	25.7
2026-07-16 00:36:07	gps_ping	V-037	D-20	R-05	riga	99.6	33.6
2026-07-16 00:36:07	gps_ping	V-032	D-30	R-08	latgale	58.7	10.1
2026-07-16 00:36:05	gps_ping	V-042	D-30	R-11	vidzeme	64.3	36.2
2026-07-16 00:36:01	trip_start	V-032	D-15	R-13	latgale	50.9	15.9
2026-07-16 00:35:59	gps_ping	V-027	D-07	R-03	kurzeme	71.9	30.7
2026-07-16 00:35:58	trip_start	V-030	D-03	R-03	kurzeme	20.5	17.5
2026-07-16 00:35:55	gps_ping	V-048	D-07	R-07	riga	39.3	27.1
2026-07-16 00:35:54	trip_end	V-012	D-08	R-04	vidzeme	57.4	28.6
2026-07-16 00:35:50	gps_ping	V-024	D-30	R-05	riga	50.6	11.6
2026-07-16 00:35:49	gps_ping	V-025	D-10	R-13	latgale	44.6	31
2026-07-16 00:35:42	gps_ping	V-003	D-26	R-13	latgale	64	33.3
2026-07-16 00:35:39	refuel	V-045	D-15	R-04	vidzeme	0	10.2
2026-07-16 00:35:36	gps_ping	V-019	D-20	R-10	latgale	88.8	32.1