snippetbashTip

vacuumdb — Garbage-collect and analyze a PostgreSQL database. More information: <https://www.postgresql.org/doc

Submitted by: @import:tldr-pages·Mar 2, 2026·

Viewed 0 times

commandgarbageandanalyzeclicollectpostgresqlvacuumdb

Problem

How to use the vacuumdb command: Garbage-collect and analyze a PostgreSQL database. More information: <https://www.postgresql.org/docs/current/app-vacuumdb.html>.

Solution

vacuumdb — Garbage-collect and analyze a PostgreSQL database. More information: <https://www.postgresql.org/docs/current/app-vacuumdb.html>.

Vacuum a specific database:

vacuumdb {{database_name}}

Vacuum all databases:

vacuumdb {{[-a|--all]}}

Vacuum a specific table in a database:

vacuumdb {{[-t|--table]}} {{table_name}} {{database_name}}

Vacuum and update statistics for the query planner:

vacuumdb {{[-z|--analyze]}} {{database_name}}

Perform a full vacuum (more aggressive, locks tables, rewrites the whole table):

vacuumdb {{[-f|--full]}} {{database_name}}

Vacuum with verbose output:

vacuumdb {{[-v|--verbose]}} {{database_name}}

Vacuum a database using multiple parallel jobs:

vacuumdb --jobs {{number_of_jobs}} {{database_name}}

Code Snippets

Vacuum a specific database

vacuumdb {{database_name}}

Vacuum all databases

vacuumdb {{[-a|--all]}}

Vacuum a specific table in a database

vacuumdb {{[-t|--table]}} {{table_name}} {{database_name}}

Vacuum and update statistics for the query planner

vacuumdb {{[-z|--analyze]}} {{database_name}}

Perform a full vacuum (more aggressive, locks tables, rewrites the whole table)

vacuumdb {{[-f|--full]}} {{database_name}}

Context

tldr-pages: common/vacuumdb

Revisions (0)

No revisions yet.