Skip to content

Glossary: PostgreSQL Beyond the Basics

pg_stat_activity

A view with one row per connection, showing its state, wait event, query and start times. It is how you find blockers, long transactions and idle sessions.

Where the book teaches it

Related terms

pg_blocking_pids()Idle in transaction