Reading Health Scores

Health Score Overview

dbaBrain assigns a letter grade (A through F) and a numeric score (0-100) to each monitored database. The score is calculated from multiple weighted factors.

Scoring Factors

• -Cache hit ratio - target above 99% (weight: 15%)
• -Connection utilization - percentage of max_connections used (weight: 10%)
• -Replication lag - seconds behind primary (weight: 15%)
• -Dead tuples - bloat level across tables (weight: 10%)
• -Long-running queries - queries over 30 seconds (weight: 15%)
• -Blocked sessions - sessions waiting for locks (weight: 15%)
• -XID wraparound risk - percentage toward wraparound (weight: 10%)
• -Checkpoint health - backend write percentage (weight: 5%)
• -Disk I/O latency - read/write latency (weight: 5%)

Grade Mapping

• -A (95-100) - Excellent. No issues detected.
• -B (85-94) - Good. Minor items to address.
• -C (70-84) - Fair. Several issues need attention.
• -D (50-69) - Poor. Significant problems affecting performance.
• -F (0-49) - Critical. Immediate action required.

Score Transparency

Click the health score on the dashboard to see a breakdown of each factor, its current value, the threshold, and how many points it contributed or deducted. Sage never produces a score without showing its work.