PostgreSQL vacuumdb utility commands
vacuumdb - utility for cleaning/analyzing PostgreSQL database. Will also generate internal statistics used by the PostgreSQL query optimizer.
vacuumdb --version
vacuumdb proddb
vacuumdb -U postgres -d testdb
vacuumdb -U postgres -a
vacuumdb -f proddb # full vacuum
vacuumdb -U postgres -d testdb -f -v
vacuumdb -U postgres -a -f --verbose
vacuumdb -F # Vacuum freeze
vacuumdb -Z proddb
vacuumdb -z proddb --echo
vacuumdb -az
vacuumdb -azf
nohup vacuumdb --full --analyze --dbname empown --host testdb.cluster-***.us-east-2.rds.amazonaws.com --port5432 --username dbadmin --verbose &
vacuumdb --help
Usage:
vacuumdb [OPTION]... [DBNAME]
Options:
-a, --all vacuum all databases
-d, --dbname=DBNAME database to vacuum
--disable-page-skipping disable all page-skipping behavior
-e, --echo show the commands being sent to the server
-f, --full do full vacuuming
-F, --freeze freeze row transaction information
--force-index-cleanup always remove index entries that point to dead tuples
-j, --jobs=NUM use this many concurrent connections to vacuum
--min-mxid-age=MXID_AGE minimum multixact ID age of tables to vacuum
--min-xid-age=XID_AGE minimum transaction ID age of tables to vacuum
--no-index-cleanup don't remove index entries that point to dead tuples
--no-process-toast skip the TOAST table associated with the table to vacuum
--no-truncate don't truncate empty pages at the end of the table
-P, --parallel=PARALLEL_WORKERS use this many background workers for vacuum, if available
-q, --quiet don't write any messages
--skip-locked skip relations that cannot be immediately locked
-t, --table='TABLE[(COLUMNS)]' vacuum specific table(s) only
-v, --verbose write a lot of output
-V, --version output version information, then exit
-z, --analyze update optimizer statistics
-Z, --analyze-only only update optimizer statistics; no vacuum
--analyze-in-stages only update optimizer statistics, in multiple stages for faster results; no vacuum
-?, --help show this help, then exit
Connection options:
-h, --host=HOSTNAME database server host or socket directory
-p, --port=PORT database server port
-U, --username=USERNAME user name to connect as
-w, --no-password never prompt for password
-W, --password force password prompt
--maintenance-db=DBNAME alternate maintenance database
Related PostgreSQL Articles: pg_dumpall commands in PostgreSQL
