Skip to main content

Activity view

The Activity tab shows a live view of what is happening on the database right now. It refreshes while active and also supports manual refresh.

What it shows​

  • Active queries — currently executing statements with duration, wait event, and query text (truncated).
  • Blocking chains — lock tree showing which PIDs are blocking which other PIDs.
  • Wait events — grouped by wait event type (Lock, IO, IPC, LWLock, etc.).
  • Long-running queries — sessions that have been active beyond a configurable duration.
  • Idle-in-transaction sessions — sessions that started a transaction but have not committed or rolled back.

Data source​

All data comes from pg_stat_activity. On PostgreSQL 14+, query_id is available for correlation with pg_stat_statements.

Caching​

The Activity tab is never cached — every load fetches live data. The auto-refresh timer is cleared when you navigate away from the tab.

Refresh​

A manual Refresh button is available for immediate reload without waiting for the 10-second interval.