Menu
Amazon Redshift
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 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 Access Control.

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.

  3. In the Cluster list, click the cluster you want to open.

  4. Click the Queries tab.

  5. Do one of the following:

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

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

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