Used to perform redshift maintenance tasks like query ANALYZE and VACUUM to help maintain performance.
Perform all maintenance tasks. Vacuum Sort, Vacuum Delete, and Analyze for all tables matching filters and thresholds.
Variables
Entry in the configs for the specified AWS redshift cluster perform maintenance on.
Specify vacuum types
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.
Will exclude any schema.tables combos that match the specified pattern. Include applies first, Exclude applied second.
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.
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.
Perform analyze maintenance tasks. Only for tables matching filters and thresholds.
Variables
Entry in the configs for the specified AWS redshift cluster perform maintenance on.
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.
Will exclude any schema.tables combos that match the specified pattern. Include applies first, Exclude applied second.
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.
Perform vacuum maintenance tasks. Only for tables matching filters and thresholds.
Variables
Entry in the configs for the specified AWS redshift cluster perform maintenance on.
Specify vacuum types
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.
Will exclude any schema.tables combos that match the specified pattern. Include applies first, Exclude applied second.
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.