Concept
Connection pool exhaustion
Connection pool exhaustion is when every connection in an application's fixed pool is in use and new requests must wait for one. It takes only a few requests that hold their connection for a long time: a slow query, or a transaction left open across a network call. Quick requests then time out waiting, although the database itself may be nearly idle.
Where you'll see it
Related concepts
Sources: Buttondown: incident write-up on connection limits ↗ · PostgreSQL documentation: connections and client defaults ↗ · Val Town: post-mortem on an exhausted connection pool ↗ · Report a problem
The definition is in our own words; the sources are those of the lesson Connection pool exhaustion.