호스트별로 느린 프런트엔드 리소스 찾기

SELECT
  resource_host,
  resource_type,
  COUNT(*) AS resources,
  approx_percentile_cont(duration_ms, 0.95) AS p95_duration_ms,
  SUM(transfer_bytes) AS transfer_bytes,
  SUM(CASE WHEN status <> 'success' THEN 1 ELSE 0 END) AS failures
FROM frontend_resource_events
WHERE timestamp_utc >= now() - INTERVAL '24 hours'
GROUP BY resource_host, resource_type
HAVING COUNT(*) >= 20
ORDER BY p95_duration_ms DESC, failures DESC;