pg_insights
A collection of convenient SQL scripts for monitoring PostgreSQL database health and performance.
What is pg_insights?
pg_insights is a collection of standalone SQL scripts for monitoring PostgreSQL database health, inspired by Heroku's pg_extras. It provides ready-to-use queries to track performance metrics like cache hit rates, index usage, and table bloat, helping administrators and developers maintain database efficiency without external tools.
PostgreSQL database administrators and developers who need to monitor database performance, identify optimization opportunities, and manage maintenance operations like vacuuming and indexing.
Developers choose pg_insights for its simplicity and seamless integration into existing PostgreSQL workflows, offering dependency-free SQL scripts that deliver essential insights without complex installations or third-party tools.
Overview
A collection of convenient SQL for monitoring Postgres database health.
Use Cases
Best For
- Monitoring PostgreSQL cache hit rates to ensure queries efficiently use in-memory shared buffers.
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.
