# pg\_activity Real time PG monitor. Source: [Console review]() Website: [https://github.com/dalibo/pg\_activity]() Profile updated: 2026-10-16 ## Supported tech stack Research checked: 2026-10-11 ### Runs on - Linux (Operating system) ### Integrates with - PostgreSQL (Integration) ### Written in - Python (Language) Source: [Research source]() Documented compatibility; coverage may be incomplete. Written in describes implementation, not user-project language support. Python PostgreSQL activity monitor supports Linux installation. ## Console’s review — 2022-10-13 Reviewed: 2022-10-13 Author: [David Mytton]() Citation: [This review]() ### 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. This review reflects Console’s assessment at publication on 2022-10-13. Features and limitations may have changed since the review date. ## Is pg\_activity a fit? Based on [Console’s review published on 2022-10-13](). Summary updated: 2026-10-16 ### 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 ## In these collections [Understand your systems](): See which Postgres queries are running, waiting, or blocking others. The review covers per-query and system statistics, with fuller visibility requiring elevated database permissions. [Selection criteria]() · [About Console]() · [Browse tools]()