pg_view is an advanced command-line utility designed for real-time monitoring of PostgreSQL databases, providing detailed insights into system and process metrics. By integrating data from PostgreSQL's process activity and system statistics, it enables users to effectively track performance, identify bottlenecks, and ensure optimal database operations during critical workloads.
Real-time per-process and global statistics from PostgreSQL
Comprehensive memory and partition utilization metrics
Multiple output formats: ncurses, console, and JSON
Autodetection of PostgreSQL clusters and manual configuration options
User-friendly hotkeys for streamlined data viewing and management