pg_activity
A top-like command-line tool for real-time monitoring of PostgreSQL server activity.
What is pg_activity?
pg_activity is a terminal-based, top-like monitoring tool for PostgreSQL databases. It provides a dynamic, real-time interface to visualize active processes, resource usage (CPU, memory, I/O), and query performance, enabling quick diagnosis of performance bottlenecks and blocking issues.
PostgreSQL database administrators and developers who need real-time, command-line visibility into database activity and performance metrics.
It offers a lightweight, interactive alternative to graphical monitoring tools with deep PostgreSQL-specific insights, direct process management capabilities (cancel/terminate), and customizable displays—all from the terminal.
Overview
pg_activity is a top like application for PostgreSQL server activity monitoring.
Use Cases
Best For
- Real-time monitoring of PostgreSQL server processes and resource usage from the command line.
- Identifying and diagnosing blocking queries and performance bottlenecks in live databases.
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
