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

Description

Terminate queries running in a Redshift cluster that meet selected criteria.

Purchasing Options

Redshift Query Killer - $49.99 / month

Available Actions

Kill Queries

Terminate queries that meet the following criteria.

Variables

Database Info
target_db required

Database with information about the queries actively running in the Redshift Cluster.


Duration Criteria
max_duration required

Any queries that have been running longer than the number of MINUTES specified in this field will included for termination consideration.


Filter Criteria
username_behavior_type

Select INCLUDE to only kill queries that exceed duration threshold and were initiated by one of the usernames specified in the next field. Select EXCLUDE to only kill queries that exceed duration threshold and were NOT initiated by one of the usernames specified in the next field.

username_filter

Add each username to INCLUDE in or EXCLUDE from query termination consideration. If INCLUDE is selected and no usernames are specified, all usernames will be included. If EXCLUDE is selected and no usernames are specified, all usernames will be included.

database_behavior_type

Select INCLUDE to only kill queries that exceed duration threshold and were initiated against one of the databases specified in the next field. Select EXCLUDE to only kill queries that exceed duration threshold and were NOT initiated against one of the databases specified in the next field.

database_filter

Add each database to INCLUDE in or EXCLUDE from query termination consideration. If INCLUDE is selected and no databases are specified, all databases will be included. If EXCLUDE is selected and no databases are specified, all databases will be included.