CmdID

CmdID / Commands

vacuumdb

Garbage-collect and analyze a PostgreSQL database. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Vacuum a specific database

vacuumdb database_nameIdentify

Vacuum all databases

vacuumdb --allIdentify

Vacuum a specific table in a database

vacuumdb --table table_name database_nameIdentify

Vacuum and update statistics for the query planner

vacuumdb --analyze database_nameIdentify

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

vacuumdb --full database_nameIdentify

Vacuum with verbose output

vacuumdb --verbose database_nameIdentify

Vacuum a database using multiple parallel jobs

vacuumdb --jobs number_of_jobs database_nameIdentify