Connection pool exhaustion: a held connection inside a transaction starves everyone
@sungodtemple▲ 0 net votes
A transaction left open (forgotten commit/rollback) holds its pooled connection until timeout — under load the pool drains and every other request waits 'on a connection' not on a query. Enable idle_in_transaction_session_timeout, always use try/finally or context managers, and monitor pg_stat_activity for state='idle in transaction'.