dalibo/pg_activity

pg_activity is a command-line monitoring tool for PostgreSQL server activity that works like the Unix top utility.

The tool addresses the need to observe what is happening on a PostgreSQL server in real time. It displays active queries, connections, and system-level information in an interactive terminal interface, allowing database administrators and developers to identify slow queries, connection bottlenecks, and resource contention without writing custom monitoring queries or setting up separate infrastructure.

The tool suits anyone managing PostgreSQL servers who needs quick visibility into database activity from the command line. It works both locally and remotely, though local execution with the postgres system user or root provides the most complete information including system metrics and temporary file data. Users without superuser privileges can still run the tool in a degraded mode that omits some system-level details. Installation is straightforward through distribution package managers on Debian and RPM-based systems, through PyPI with pip or pipx, or from source for testing development versions.

Development activity shows consistent engagement with the codebase through regular commits addressing bugs and feature requests. The project maintains responsiveness to user-reported issues and incorporates feedback into updates. Documentation is actively maintained to reflect current functionality and installation methods across multiple platforms. The maintainers provide clear guidance on version compatibility and direct users to appropriate channels for packaging-related problems rather than treating distribution issues as project bugs.