You can't use this until you register with us!




Description

Perform vacuum reindex, vacuum sort, vacuum delete and analyze on Redshift database tables.


Purchasing Options



Available Actions

Vacuum and Analyze

Perform a Vacuum, then an Analyze for all tables matching the specified filter and threshold options.


Variables

Maintenance Options
redshift_connection required

Select the Redshift database to perform maintenance on.

vacuum_type required

Select the type of Vacuum that you would like to perform.


Filter Options
include

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.

exclude

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.


Threshold Options
sort_threshold

Exclude tables where the percentage of the table that is physically unsorted on disk is less than the value specified.

stats_threshold

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.


Analyze

Perform an Analyze for all tables matching the filter and threshold parameters.


Variables

Maintenance Options
redshift_connection required

Select the Redshift database to perform maintenance on.


Pattern Options
include

Include tables with names that match the specified pattern. Leave blank to include all tables.

exclude

Exclude tables with names that match the specified pattern from the results of the Include Pattern.


Threshold Options
stats_threshold

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.


Vacuum

Perform a Vacuum for all tables matching the filter and threshold parameters.


Variables

Maintenance Options
redshift_connection required

Select the Redshift database to perform maintenance on.

vacuum_type required

Select the type of Vacuum that you would like to perform.


Pattern Options
include

Include tables with names that match the specified pattern. Leave blank to include all tables.

exclude

Exclude tables with names that match the specified pattern from the results of the Include Pattern.


Threshold Options
sort_threshold

Exclude tables where the percentage of the table that is physically unsorted on disk is less that the value specified.