Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Vacuum and analyze

Run vacuum/analyze from the shell.

Back to sheetBrowse commands
Sign in to save
Section: Database Administration Utilities

Vacuum and analyze

bash
bash
vacuumdb -h localhost -U postgres -d appdb --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 Database Administration Utilities
Collect planner stats
Refresh planner statistics for a table.
OpenIn sheetsqlsame section
Create database from shell
Create a database using the `createdb` utility.
OpenIn sheetbashsame section
Drop database from shell
Drop a database using the `dropdb` utility.
OpenIn sheetbashsame section
Create role from shell
Interactively create a new role.
OpenIn sheetbashsame section
Drop role from shell
Remove a role using the command-line utility.
OpenIn sheetbashsame section
Reindex database
Rebuild indexes in a database.
OpenIn sheetbashsame section