Postgres maintenance audit for autovacuum and table health
Database Optimization Tool reviews PostgreSQL maintenance signals without changing production, then keeps recommendations evidence-gated and advisory for human planning.
Maintenance evidence reviewed
The audit compares estimated live rows, estimated dead rows, last vacuum, last autovacuum, last analyze, relation size, and surrounding workload signals to identify maintenance review candidates.
Autovacuum and analyze drift
Stale maintenance timestamps, rising dead-row pressure, and stale planner statistics can point to tables where PostgreSQL maintenance needs closer human review.
Bloat signals with clear limits
The report can flag table-health and growth signals, but it does not claim exact reclaimable space unless the collected PostgreSQL evidence supports that level of detail.
Advisory-only maintenance planning
Database Optimization Tool does not run VACUUM, VACUUM FULL, REINDEX, or configuration changes. AI-assisted notes stay advisory and require human review before action.
Frequently asked questions
These answers describe the product focus: careful database evidence, clear findings, and team-approved next steps.
Does Database Optimization Tool run PostgreSQL maintenance commands?
No. It is evidence-focused. It does not run VACUUM, VACUUM FULL, REINDEX, ANALYZE, or autovacuum configuration changes.
What does a maintenance audit finding mean?
It means collected PostgreSQL evidence suggests a table or workload needs review. It is not an instruction to run a disruptive production command immediately.
Can AI decide the maintenance plan?
No. AI-assisted notes are advisory only. Evidence Gate controls official findings, and the database owner decides maintenance timing, lock risk, and rollback planning.
Is this continuous autovacuum monitoring?
No. It is a evidence-focused audit based on collected PostgreSQL evidence. It does not provide real-time monitoring or alerts.