Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/Analyze upgraded cluster

Collect statistics after a fresh restore or upgrade.

Back to sheetBrowse commands
Sign in to save
Section: Cluster-wide Backup and Migration

Analyze upgraded cluster

bash
bash
vacuumdb --all --analyze-in-stages
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Cluster-wide Backup and Migration
Run pg_upgrade check
Check whether an in-place major upgrade is feasible.
OpenIn sheetbashsame section
Run pg_upgrade
Perform an in-place major version upgrade.
OpenIn sheetbashsame section
Dump global objects
Export cluster-wide roles and tablespaces.
OpenIn sheetbashsame section
Dump entire cluster
Dump all databases in one plain SQL file.
OpenIn sheetbashsame section
Physical base backup
Take a physical base backup suitable for replication or disaster recovery.
OpenIn sheetbashsame section
Verify base backup
Verify integrity of a base backup manifest.
OpenIn sheetbashsame section