pg_stat_activity, and the transaction left open
The view that says what the server is doing right now, the state that blocks everything while using no CPU, and a query plan read in one line.
24 minutesTechnical content last reviewed on 16 Sept 2026
This lesson is for signed-in learners
Create an account to subscribe and record your learning progress.
What this lesson builds
- Administering PostgreSQL: access, connections and growth
- Reading system state without over-reading it