User guide

Use the button bar, shown following, to refresh the data in the table, to configure the columns that appear
in the table, or to open the Amazon Redshift documentation.
To view query performance data
1. Sign in to the AWS Management Console, and open the Amazon Redshift console at https://
console.aws.amazon.com/redshift.
2. In the left navigation, click Clusters.
3. In the Cluster list, click the magnifying glass icon beside the cluster for which you want to view
performance data.
4. Select the Queries tab.
By default, the Queries tab displays query performance over the past 24 hours.To change the data
displayed, use the Filter list to select the time period for which you want to view queries, or type a
keyword in the Search box to search for queries that match your search criteria.
Terminating a Running Query
You can also use the Queries page to terminate a query that is currently in progress.
Note
The ability to terminate queries and loads in the Amazon Redshift console requires specific
permission. If you select the Amazon Redshift Read Only AWS managed policy or create a
custom policy in IAM, and you want users to be able to terminate queries and loads, make sure
to add the redshift:CancelQuerySession action to the policy. Users who have the Amazon
Redshift Full Access policy already have the necessary permission to terminate queries and
loads. For more information about actions in IAM policies for Amazon Redshift, see IAM Policy
Actions for Amazon Redshift (p. 118).
To terminate a running query
1. Sign in to the AWS Management Console, and open the Amazon Redshift console at https://
console.aws.amazon.com/redshift.
2. In the left navigation pane, click Clusters.
API Version 2012-12-01
187
Amazon Redshift Management Guide
Viewing Query Performance Data