Perform vacuum delete, vacuum reindex, vacuum sort or 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.
Exclude tables where the vacuum_sort_benefit value is less than the value specified. The vacuum_sort_benefit value ranges from 0 to 100 and indicates the percent chance to improve query performance based on the sort status of the portion of the table most frequently accessed by queries.
Perform an Analyze for all tables matching the filter and threshold parameters.
Variables
Select the Redshift database to perform maintenance on.
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 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 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.
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 vacuum_sort_benefit value is less than the value specified. The vacuum_sort_benefit value ranges from 0 to 100 and indicates the percent chance to improve query performance based on the sort status of the portion of the table most frequently accessed by queries.