VACUUM [ VERBOSE ] [ ANALYZE ] [ table ] VACUUM [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]
Pass this parameter to force VACUUM to display an activity report for each table it operates upon.
Pass this parameter to force VACUUM to update column statistics for the optimizer.
Use this parameter to specify a table you wish to vaccum. If you do not specify a table, VACUUM will operate upon all tables.
This parameter takes the name of a column to analyze (used when updating statistics for the optimizer).
This message is displayed if the VACUUM successfully vacuums a database or table.
This message is displayed when VACUUM begins cleaning a table while in verbose mode.
This information is the output displayed by an analysis on the books table. The values displayed would be different if the command was performed upon a different table, but the format would be the same.
This is the output printed for an analysis on an index of the specified table.
Use the VACUUM command to clean up records from rolled back transactions and update system catalog statistics. Call it with the ANALYZE option to collect statistical information about data. Using this command periodically can inrease the performance of your database.
The following example displays the output of VACUUM when run on the books table.
booktown=# VACUUM VERBOSE BOOKS;
NOTICE: --Relation books--
NOTICE: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 15:
Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 5, MinLen 52,
MaxLen 76; Re-using: Free/Avail. Space 7108/0;
EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: Index books_id_pkey: Pages 2; Tuples 15: Deleted 0.
CPU 0.00s/0.00u sec.