auditing-operational-health

What problem does it solve?

This Skill addresses the silent degradation of PostgreSQL databases by proactively monitoring and diagnosing critical operational health issues before they cause catastrophic failures.

Core Features & Use Cases

• XID Wraparound Monitoring: Detects and alerts on the risk of transaction ID exhaustion, which can force emergency shutdowns.
• Bloat Detection: Identifies table and index bloat caused by accumulated dead tuples, which impacts performance and disk usage.
• Autovacuum Tuning Guidance: Provides insights and parameters for optimizing PostgreSQL's background maintenance processes.
• Performance Metrics: Analyzes cache hit ratios and sequential scan rates to pinpoint performance bottlenecks.
• Use Case: When experiencing unexplained database slowdowns, this Skill can be used to diagnose issues related to XID wraparound, table bloat, or inefficient vacuuming, providing actionable queries and thresholds for remediation.

Quick Start

Use the auditing-operational-health skill to check the XID wraparound status for all databases.