pg_insights: PostgreSQL Health Monitoring Tool
pg_insights is a powerful SQL-based tool designed for monitoring the health and performance of PostgreSQL databases. Inspired by Heroku's command set, it provides a comprehensive suite of scripts that allow database administrators to easily analyze autovacuum operations, bloat, cache hit rates, and other crucial metrics to ensure optimal database performance.
Features
Monitor running autovacuums and analyze their impact on performance.
Assess table and index bloat, enabling targeted maintenance actions.
Evaluate shared buffer usage and cache hit rates for efficient memory management.
Identify rarely used indices to optimize query performance.
Retrieve detailed statistics on table sizes, including indices and data.
Reset pg_stats statistics for accurate monitoring.