PostgreSQL Health Checks


PostgreSQL Health Checks run server-level checks and show findings that may affect reliability, performance, and maintainability.

Mini DBA PostgreSQL health checks

Workflow

  1. Open Health Checks.
  2. Run or refresh checks.
  3. Review severity, finding, and recommendation.
  4. Follow links or use related pages for supporting evidence.
  5. Re-run checks after remediation.

How To Prioritize PostgreSQL Health Checks

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.

PostgreSQL Health Check FAQ

Should every warning be fixed immediately?

No. Prioritize by severity, production impact, recurrence, and effort. Some warnings may be accepted temporarily with a documented reason.

Why did a finding reappear?

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.

Can health checks replace manual DBA review?

No. They help surface common risks and evidence, but production changes should still follow your normal review and testing process.

Health Check Reference

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

Related Pages