0.13
postgres_ai monitoring v0.13 - release notes
What's new
Kubernetes support (Helm charts)
Complete Kubernetes deployment support via Helm charts, including: (!72)
- Full monitoring stack deployment (PGWatch, VictoriaMetrics, Grafana)
- CronJob-based reporter for automated health checks
- Configurable ingress with TLS support
- Persistent storage via StatefulSets
- Helm chart: postgres-ai-monitoring-0.13.tgz
New dashboard: "13. Lock contention"
New metric and dedicated dashboard for detailed lock contention analysis: (!82, !84, !86)
- Blocked and blocking process identification
- Lock modes and types visualization
- Affected tables and queries
- Wait duration and transaction time tracking
- "Database: All" filter option
OAuth support for Grafana
Added OAuth authentication support for Grafana with configurable providers, enabling SSO integration; allows authentication using PostgresAI account (limited to members of specific organization that owns monitoring instance) (!79)
Issue generation API
New issue_generation flag in report file API for automated issue creation workflows. (!69)
Dashboard improvements
- Dashboard 2 (Aggregated Query Analysis): Added 'per second' to titles and proper XXX/s units; added "Database: All" filter option (!88, !87)
- Dashboard 3 (Single Query Analysis): Show detailed wait events in Active Session History panel (!76)
- Dashboard 4 (Wait Sampling): Added "DB name: All" filter, now default selection (!78)
- Dashboard 12 (SLRU): Renamed title to '12. SLRU cache stats' for consistency (!89)
Performance improvements
- Reduced VictoriaMetrics load: Metrics now filter queries by current_database() to reduce cardinality and improve query performance (!80)
Fixes
- Reporter queries: Fixed and improved metric queries for better data reliability (!73)
- Database discovery: Made DB discovery source-agnostic for better compatibility (!70)
- H004 report: Now includes index_definition field (consistent with H002) (!71)