Database Optimization Tool
Maintenance audit

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.

Autovacuum drift review
Dead-row pressure
Table and index size signals
Maintenance decisions stay with your team

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.

Keep exploring

Use these short guides to compare query pressure, index decisions, and maintenance signals before planning production work.

FAQ

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.