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




Description

Used to perform redshift maintenance tasks like query ANALYZE and VACUUM to help maintain performance.



Available Actions

Perform All

Perform all maintenance tasks. Vacuum Sort, Vacuum Delete, and Analyze for all tables matching filters and thresholds.


Variables

redshift_connection required

Entry in the configs for the specified AWS redshift cluster perform maintenance on.


vacuum_type required

Specify vacuum types


include

Will only include schema.tables combos that match the specified pattern. Include applies first, Exclude applied second. If empty includes all tables unless filtered by exclude/sort/stats.


exclude

Will exclude any schema.tables combos that match the specified pattern. Include applies first, Exclude applied second.


Thresholds
sort_threshold

Will only sort tables where the the `unsortedness` is greater then or equal than this number. IE if you enter 50 then will run on tables who are unsorted for more than 50% of the table.

stats_threshold

Will only analyze tables where the the `stats off` is greater then or equal than this number. IE if you enter 50 then will run on tables whose stats are more than 50% off.


Analyze Only

Perform analyze maintenance tasks. Only for tables matching filters and thresholds.


Variables

redshift_connection required

Entry in the configs for the specified AWS redshift cluster perform maintenance on.


include

Will only include schema.tables combos that match the specified pattern. Include applies first, Exclude applied second. If empty includes all tables unless filtered by exclude/sort/stats.


exclude

Will exclude any schema.tables combos that match the specified pattern. Include applies first, Exclude applied second.


Thresholds
stats_threshold

Will only analyze tables where the the `stats off` is greater then or equal than this number. IE if you enter 50 then will run on tables whose stats are more than 50% off.


Vacuum Only

Perform vacuum maintenance tasks. Only for tables matching filters and thresholds.


Variables

redshift_connection required

Entry in the configs for the specified AWS redshift cluster perform maintenance on.


vacuum_type required

Specify vacuum types


include

Will only include schema.tables combos that match the specified pattern. Include applies first, Exclude applied second. If empty includes all tables unless filtered by exclude/sort/stats.


exclude

Will exclude any schema.tables combos that match the specified pattern. Include applies first, Exclude applied second.


Thresholds
sort_threshold

Will only sort tables where the the `unsortedness` is greater then or equal than this number. IE if you enter 50 then will run on tables who are unsorted for more than 50% of the table.