pg_activity

Real time PG monitor.

Visit website ↗

Profile updated

Console’s review

· Reviewed by David Mytton

What we like

Displays Postgres stats and queries in a real time terminal interface. Toggle running, waiting, blocking queries. Includes system info (CPU, memory, query counters) and on a per query level. Query table can be sorted and refresh paused. Has a special flag for optimized RDS support.

Tradeoffs

Minimum refresh rate of 0.5 is too infrequent to show fast queries, but those are probably not the ones you’re interested in anyway. Requires superuser to get all the data, but falls back to display what it can without superuser.

Is pg_activity a fit?

Based on Console’s review published on 2022-10-13. Summary updated .

Who it’s for

Developers using Postgres

Why consider it

Displays Postgres stats and queries in real time

Keep in mind

Has a minimum refresh rate that may be too infrequent for fast queries

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects Console’s assessment at publication on 2022-10-13. Features and limitations may have changed since the review date. Read our selection criteria and learn about Console.

Discover your next favorite tool

Independent devtool reviews and the latest betas, in your inbox every Thursday. Free.