Release Date: November 10, 2025
GitLab Issue:#48

Overview

Version 0.12.0 adds SLRU monitoring, multixact member space exhaustion detection, enhanced dashboard usability, and improved automated reporting for production Postgres databases.

New features

SLRU monitoring dashboard (!65)

New dedicated dashboard for monitoring Simple Least Recently Used (SLRU) caches throughpg_stat_slru metrics. Provides visibility into CLOG, subtransaction cache, multixact offset and member cache performance. SLRU contention can cause severe performance degradation that is difficult to diagnose without proper monitoring.

MultiXact member space exhaustion (!66)

Added early warning metric for multixact member space exhaustion by monitoringpg_multixact/members directory size. Provides advance notice before emergency autovacuum triggers. Documentation updated with required permissions for RDS/Aurora and self-managed instances.

High-level troubleshooting metrics (!67)

Redesigned Dashboard 1 to use high-level system metrics instead of granularpg_stat_statements aggregations. Provides faster dashboard load times (2-3x improvement), more intuitive top-down troubleshooting workflow, and better alignment with Four Golden Signals methodology.

Enhanced unused indexes report (!64)

• Index definitions included for one-command UNDO operations
• Improved statistics age calculation using database uptime whenstats_reset is NULL
• Enhanced metadata for safer index cleanup decisions

Other minor improvements

• Active Session History (Dashboard 4) legibility improvements
• Aggregated table statistics table on Dashboard 8
• Got rid of hard-coded inner passwords for sink-postgres

Bug fixes

• Corrected grant statements in documentation
• Multi-value tooltips on Dashboard 1 enable time-synchronized analysis across all metrics

Linked merge requests

• !68 — Dashboard improvements (shared tooltips, ASH)
• !67 — High-level metrics on Dashboard 1
• !66 — Multixact folder size monitoring
• !65 — SLRU metrics and dashboard
• !64 — Unused indexes report improvements

References

• GitLab Issue:https://gitlab.com/postgres-ai/postgres_ai/-/issues/48
• Repository:https://github.com/postgres-ai/postgres_ai /https://gitlab.com/postgres-ai/postgres_ai
• Live Demo:https://demo.postgres.ai