clickhouse-managed-postgres-rca

Diagnose slow queries on managed Postgres by collecting Prometheus metrics to establish workload context and retrieving per-pattern latency evidence from the Slow Query Patterns API to identify dominant bottlenecks.

Evidence-based root cause analysis for managed Postgres correlates system signals from Prometheus with per-digest evidence from the Slow Query Patterns API to triage issues and output a structured, recommend-only action plan.

Triage full-scan, hot-loop, and write-congestion slow query patterns in Postgres by applying a compact heuristic library that correlates Prometheus system signals with API-retrieved per-pattern evidence to generate actionable recommendations.

Yes, OpenAPI-driven discovery resolves endpoints for Postgres slow query analysis by dynamically building a role map that adapts to evolving API shapes to successfully retrieve per-pattern evidence.

No, managed Postgres root cause analysis produces a safe, recommend-only RCA report that explicitly avoids mutating the target instance during the diagnostic triage and recommendation workflow.