Perform vacuum reindex, vacuum sort, vacuum delete and analyze on Redshift database tables.
Perform a Vacuum, then an Analyze for all tables matching the specified filter and threshold options.
Variables
Select the Redshift database to perform maintenance on.
Select the type of Vacuum that you would like to perform.
Provide a list of strings or characters separated by spaces. Only tables with names that contain one of the characters or strings will be included. Leave blank to include all tables.
Provide a list of strings or characters separated by spaces. Any tables with names that contain one of the characters or strings will be removed from the results created by the Include Filter.
Exclude tables where the percentage of the table that is physically unsorted on disk is less than the value specified.
Exclude tables where the stats_off value is less than the value specified. The stats_off value ranges from 0 to 100 and indicates how stale the table statistics have become since the last time an Analyze operation was performed.
Perform an Analyze for all tables matching the filter and threshold parameters.
Variables
Select the Redshift database to perform maintenance on.
Include tables with names that match the specified pattern. Leave blank to include all tables.
Exclude tables with names that match the specified pattern from the results of the Include Pattern.
Exclude tables where the stats_off value is less that the value specified. The stats_off value ranges from 0 to 100 and indicates how stale the table statistics have become since the last time an Analyze operation was performed.
Perform a Vacuum for all tables matching the filter and threshold parameters.
Variables
Select the Redshift database to perform maintenance on.
Select the type of Vacuum that you would like to perform.
Include tables with names that match the specified pattern. Leave blank to include all tables.
Exclude tables with names that match the specified pattern from the results of the Include Pattern.
Exclude tables where the percentage of the table that is physically unsorted on disk is less that the value specified.