pg_stat_monitor
An advanced PostgreSQL extension for query performance monitoring, aggregating statistics in configurable time buckets.
What is pg_stat_monitor?
pg_stat_monitor is a PostgreSQL extension for monitoring and analyzing query performance. It collects and aggregates query execution statistics in configurable time buckets, providing detailed insights into query origins, execution plans, and performance metrics. It solves the problem of fragmented query performance data by offering a consolidated view that helps database administrators and developers debug and optimize SQL queries.
Database administrators, DevOps engineers, and backend developers who manage PostgreSQL databases and need detailed query performance insights for tuning and troubleshooting.
Developers choose pg_stat_monitor over alternatives like pg_stat_statements because it provides aggregated statistics in time-based buckets, captures actual query parameters and execution plans, and offers multi-dimensional grouping for more precise analysis, all in a single view.
Overview
Query Performance Monitoring Tool for PostgreSQL
Use Cases
Best For
- Monitoring PostgreSQL query performance in production environments
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.
