pgwatch2: PostgreSQL Metrics Monitoring and Dashboarding Tool
pgwatch2 is a versatile, self-contained monitoring solution for PostgreSQL that enables users to visualize and analyze metrics from versions 9.0 to 16. Designed for minimal intrusion, it supports a variety of deployment methods including Docker, Kubernetes, and standalone configurations, making it suitable for both small-scale and enterprise-level environments.
Features
Non-invasive setup requiring no superuser privileges or extensions for basic functionality
Customizable metrics presentation through Grafana with built-in alerting capabilities
Support for multiple metrics storage options, including PostgreSQL, TimescaleDB, InfluxDB, and Prometheus
Extensive pre-configured dashboards and metric configurations for comprehensive monitoring
Flexible deployment options, including 'push' and 'pull' models, to fit various architecture preferences
Low resource consumption, capable of monitoring thousands of databases with minimal hardware requirements
Integration of OS-level metrics for holistic monitoring beyond PostgreSQL performance