PostgreSQL Health Checks run server-level checks and show findings that may affect reliability, performance, and maintainability.
PostgreSQL Health Checks help convert routine monitoring data into an actionable maintenance list. Treat high-severity findings as candidates for immediate review, but also consider business impact. A warning on a critical production database can matter more than a high-severity item on a test system.
Group findings by type before assigning work. Configuration findings may belong to the DBA or platform team, query and index findings may require developer input, and availability or backup findings may need operational ownership. Use supporting pages such as PostgreSQL Settings, PostgreSQL Indexes, and PostgreSQL Server Log to validate each recommendation.
Health checks are most valuable when run regularly. Save or report the current state, fix the highest-impact items, then re-run checks to confirm the finding has cleared. This creates a clear improvement record for audits, managed service reviews, and internal reliability work.
No. Prioritize by severity, production impact, recurrence, and effort. Some warnings may be accepted temporarily with a documented reason.
The underlying condition may have returned, the change may not have applied to the monitored server, or the finding may depend on workload that changed after remediation.
No. They help surface common risks and evidence, but production changes should still follow your normal review and testing process.
The following Mini DBA PostgreSQL health check detail pages explain the purpose of each check and the actions to take when a check fails.
| Health check | Category | Detail |
|---|---|---|
| Auth Delay Enabled | Configuration | Open detail |
| Auto Explain Enabled | Configuration | Open detail |
| Auto Vacuum Enabled | Configuration | Open detail |
| Autovacuum Vacuum Scale Factor | Configuration | Open detail |
| Autovacuum Work Mem | Configuration | Open detail |
| Autovacuum Worker Capacity | Configuration | Open detail |
| Effective Cache Size | Configuration | Open detail |
| Extension Currency | Configuration | Open detail |
| FSync Enabled | Configuration | Open detail |
| Idle In Transaction Session Timeout | Configuration | Open detail |
| Maintenance Work Mem | Configuration | Open detail |
| Max Connections | Configuration | Open detail |
| Minimum TLS Version | Configuration | Open detail |
| Old Authentication Method | Configuration | Open detail |
| Pg Stats Enabled | Configuration | Open detail |
| Random Page Cost | Configuration | Open detail |
| Restart Pending Settings | Configuration | Open detail |
| Shared Buffers | Configuration | Open detail |
| SSL Enabled | Configuration | Open detail |
| Track Counts Enabled | Configuration | Open detail |
| Track IO Timing Enabled | Configuration | Open detail |
| Unrestricted Listen Addresses | Configuration | Open detail |
| Work Mem | Configuration | Open detail |
| Logging Incident Readiness | Monitoring | Open detail |
| Autovacuum Due Tables | Performance | Open detail |
| High Dead Tuple Ratio | Performance | Open detail |
| Invalid Indexes | Performance | Open detail |
| Missing Analyze History | Performance | Open detail |
| Missing Vacuum History | Performance | Open detail |
| Unused Indexes | Performance | Open detail |
| PostgreSQL Version Currency | Reliability | Open detail |
| Replication Slot Hygiene | Reliability | Open detail |
| Wraparound Age | Reliability | Open detail |