pg_activity

Real time PG monitor.

Visit website ↗

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.

Console is a free weekly newsletter with short reviews of developer tools, covering strengths and tradeoffs. This review reflects our assessment at publication. 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.