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

Viewing Cluster Metrics During Load Operations

When you view cluster performance during load operations, you can identify queries that are consuming resources and take action to mitigate their effect. You can terminate a load if you don't want it to run to completion.

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 view cluster metrics during load operations

  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 for which you want to view cluster performance during query execution.

  4. Choose the Loads tab.

  5. In the load list, find the load operation you want to work with, and choose the load ID in the Load column.

  6. In the new Query tab that is opened, you can view the details of the load operation.

    At this point, you can work with the Query tab as shown in Viewing Query Performance Data. You can review the details of the query and see the values of cluster metrics during the load operation.

To terminate a running load

  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 that you want to open.

  4. Choose the Loads tab.

  5. Do one of the following:

    • In the list, select the load or loads that you want to terminate, and choose Terminate Load.

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

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