Measure database connection timeouts and churn

SELECT
  service,
  region,
  SUM(CASE WHEN event_name = 'opened' THEN 1 ELSE 0 END) AS opened,
  SUM(CASE WHEN event_name = 'closed' THEN 1 ELSE 0 END) AS closed,
  SUM(CASE WHEN event_name = 'acquisition_timeout' THEN 1 ELSE 0 END)
    AS acquisition_timeouts,
  SUM(CASE WHEN event_name = 'connection_error' THEN 1 ELSE 0 END)
    AS connection_errors,
  COUNT(DISTINCT CASE
    WHEN event_name IN ('acquisition_timeout', 'connection_error') THEN request_id
  END) AS affected_requests
FROM database_connection_events
WHERE timestamp_utc >= now() - INTERVAL '24 hours'
GROUP BY service, region
ORDER BY acquisition_timeouts DESC, connection_errors DESC;