check_database_health
Analyze PostgreSQL database health by checking connections, cache performance, lock contention, replication status, and disk usage. Get health scores and improvement recommendations.
Instructions
Perform a comprehensive database health check.
Analyzes multiple aspects of PostgreSQL health:
Connection statistics and pool usage
Cache hit ratios (buffer and index)
Lock contention and blocking queries
Replication status (if configured)
Transaction wraparound risk
Disk space usage
Background writer statistics
Checkpoint frequency
Returns a health score with detailed breakdown and recommendations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_recommendations | No | Include actionable recommendations | |
| verbose | No | Include detailed statistics |
Input Schema (JSON Schema)
{
"properties": {
"include_recommendations": {
"default": true,
"description": "Include actionable recommendations",
"type": "boolean"
},
"verbose": {
"default": false,
"description": "Include detailed statistics",
"type": "boolean"
}
},
"required": [],
"type": "object"
}