Alert: PostgresConnectionPoolHigh¶
Symptom¶
Active Postgres connections exceed 80% of max_connections on lastvet-db.
Immediate action¶
ssh lastvet-db "sudo -u postgres psql -c \"SELECT count(*), state FROM pg_stat_activity GROUP BY state;\""
Diagnosis¶
- API connection pool misconfiguration or connection leak.
- Long-running queries blocking pool.
- Deploy causing connection spike.
Escalation¶
Ryan if API returns 503/timeout to clients.
Resolution history¶
| Date | Notes |
|---|---|