Online Documentation for SQL Manager for PostgreSQL
Setting vacuum parameters
This step of the wizard allows you to specify basic vacuum parameters to be applied to the VACUUM operation.
Show detailed operation report
Check this option to receive a detailed vacuum activity report for each table (VERBOSE).
Update optimization statistics
This option updates statistics used by the optimizer to determine the most efficient way to execute a query (ANALYZE).
Compact unused space
This option specifies "full" vacuum which may reclaim more space, but takes much longer and exclusively locks the table (FULL).
This option enforces "freezing" of tuples (FREEZE). This option is recommended for read-only databases.
Click the Next button to proceed to the Selecting tables step of the wizard.