pg_activity

pg_activity is a command-line monitoring tool for PostgreSQL that displays server activity and performance metrics in a format similar to the Unix top utility. It allows developers and database administrators to observe running queries, connections, and system resource usage in real time through an interactive interface. The tool is written in Python and developed by dalibo, released under the PostgreSQL License. It provides a straightforward way to diagnose performance issues and track database operations without requiring external dependencies or complex configuration, making it useful for anyone managing PostgreSQL instances from the command line.

The tool integrates into standard terminal workflows and offers dynamic sorting and filtering capabilities for investigating database activity. Its top-like design makes it intuitive for users already familiar with system monitoring tools, presenting information in a compact, scrollable format suitable for production environments and development workflows alike.