Menu
Amazon Redshift
Cluster Management Guide (API Version 2012-12-01)

Viewing Query Performance Data

The Amazon Redshift console provides information about performance of queries that run in the database. You can use this information to identify and troubleshoot queries that take a long time to process and that create bottlenecks preventing other queries from processing efficiently. You can use the Queries tab on the cluster details page to view this information. The Queries tab shows a table that lists queries that are currently running or have run recently in the cluster.

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 navigation pane, choose Clusters.

  3. For Cluster, choose the magnifying glass icon beside the cluster for which you want to view performance data.

  4. Choose 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. You can also 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 want users to be able to terminate queries and loads, make sure to add the redshift:CancelQuerySession action to your AWS Identity and Access Management (IAM) policy. This requirement applies whether you select the Amazon Redshift Read Only AWS-managed policy or create a custom policy in IAM. 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 Managing Access to Resources.

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 navigation pane, choose Clusters.

  3. For Cluster, choose the cluster you want to open.

  4. Choose the Queries tab.

  5. Do one of the following:

    • In the list, select the query or queries that you want to terminate, and choose Terminate Query.

    • In the list, open a query if you want to review the query information first, and then choose Terminate Query.

  6. In the Terminate Queries dialog box, choose Confirm.