Connections

A query is blocked waiting for a lock held by another session. This creates a blocking chain that can cascade to affect multiple queries.

The database is approaching its max_connections limit. New connections may fail if the limit is reached.

A connection has been idle for an extended period, consuming a connection slot without doing useful work.

A connection is in "idle in transaction" state, holding locks and preventing VACUUM from cleaning up dead tuples.

A query has been executing for more than 5 minutes, which may indicate a performance problem or runaway operation.

A transaction has been open for more than 5 minutes, which may indicate a problem and can prevent vacuum from cleaning up dead tuples.