yesid@transit:gold> EN DIRECT
SELECT
d.route_short_name,
round(avg(f.delay_seconds)::numeric, 1)
AS avg_delay_s,
count(DISTINCT f.vehicle_id)
AS vehicles
FROM gold.latest_trip_delay_snapshot f
JOIN gold.dim_route d
USING (provider_id, route_id)
WHERE f.delay_seconds IS NOT NULL
GROUP BY d.route_short_name
ORDER BY vehicles DESC
LIMIT 5;
route avg_delay_s vehicles 24 32.1 2880 51.7 24121 18.4 2251 44.9 19165 27.6 17
5 lignes · 0.023s · mis à jour il y a 30 s
Rafraîchit les métriques et les résultats de requête à partir du pipeline en direct
