pg_activity
A top-like command-line tool for real-time monitoring of PostgreSQL server activity.
What is pg_activity?
pg_activity is a command-line tool that provides a top-like interface for monitoring PostgreSQL server activity in real time. It displays running queries, resource usage (CPU, memory, I/O), locks, and other critical metrics, helping administrators diagnose performance issues and manage database workloads.
PostgreSQL database administrators, DevOps engineers, and developers who need to monitor and troubleshoot database performance from the terminal.
It offers a lightweight, interactive, and feature-rich alternative to built-in PostgreSQL views, with customizable displays, keyboard-driven navigation, and support for both local and remote instances.
Overview
pg_activity is a top like application for PostgreSQL server activity monitoring.
Use Cases
Best For
- Real-time monitoring of PostgreSQL query performance and resource usage
- Identifying and terminating blocking or long-running queries
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.
