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

Viewing Cluster Performance During Query Execution

You can use the Cluster Performance During Query Execution section of the Query view to see cluster metrics during query execution to help identify poorly performing queries, look for bottleneck queries, and determine if you need to resize your cluster for your workload.

To view cluster metrics during query execution

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

  4. Click the Queries tab.

  5. In the query list, find the query you want to work with, and click the query ID in the Query column.

    In the following example, the queries are sorted by Run time to find the query with the maximum run time.

  6. In the Query page that opens, scroll to the Cluster Performance During Query Execution section to view cluster metrics.

    In the following example, the CPUUtilization and NetworkReceiveThroughput metrics are displayed for the time that this query was running.

    Tip

    You can close the details of the Query Execution Details or SQL sections to manage how much information is displayed in the pane.