按路由計算 API 請求吞吐量

SELECT
  route_template,
  COUNT(*) AS requests,
  SUM(CASE WHEN status_code >= 500 THEN 1 ELSE 0 END) AS errors,
  60.0 * COUNT(*) / NULLIF(
    date_part('epoch', MAX(timestamp_utc) - MIN(timestamp_utc)),
    0
  ) AS requests_per_minute
FROM api_throughput_events
WHERE timestamp_utc >= now() - INTERVAL '24 hours'
  AND environment = 'production'
GROUP BY route_template
ORDER BY requests_per_minute DESC, route_template;