pg_top ☆

« Back to VersTracker

Description:
Monitor PostgreSQL processes

Type: Formula | Tracked Since: Dec 28, 2025

Links: Homepage | formulae.brew.sh

Category: Databases

Tags: postgresql monitoring database cli admin

Install: brew install pg_top

About:
pg_top is a command-line monitoring tool that provides a real-time, top-like interface for PostgreSQL database activity. It displays active queries, connection information, and server statistics, allowing administrators to quickly identify performance bottlenecks and resource contention. The tool is invaluable for live troubleshooting and maintaining database health.

Key Features:

Real-time monitoring of PostgreSQL processes and queries
Displays active queries, locks, and connection details
Top-like interactive interface for easy navigation
Supports multiple PostgreSQL server versions

Use Cases:

Diagnosing slow queries and performance issues in real-time
Monitoring database connections and identifying idle or blocking processes
Troubleshooting live production database environments

Alternatives:

pg_stat_statements – Built-in extension for query statistics history, whereas pg_top provides live, real-time monitoring.
htop – General system resource monitor, whereas pg_top is specialized for PostgreSQL internal processes.

Version History

Detected	Version	Rev	Change	Commit