analyze_db_health
Run catalog-based PostgreSQL health checks covering connections, idle transactions, long queries, cache hit rate, indexes, constraints, wraparound, sequences, and replication without extensions.
Instructions
Eleven deterministic checks over the system catalog: connections, idle transactions, long queries, cache hit rate, invalid, unused and duplicate indexes, constraints, wraparound, sequences, replication. No extensions required. A check returns skipped, not ok, when the role lacks the privilege or the statistics window is too short to judge; overall_status is unknown when nothing could be checked.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection_id | Yes | Connection id. See list_connections. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |