select route, quantile(0.99, latency_ms) as p99
from requests
where ts > now() - 1h and status < 500
group by route order by p99 desc limit 8