Viewing cluster performance as queries run - Amazon Redshift

Viewing cluster performance as queries run

Note

A new console is available for Amazon Redshift. Choose either the New console or the Original console instructions based on the console that you are using. The New console instructions are open by default.

To display cluster performance as queries run

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. On the navigation menu, choose CLUSTERS, then choose the cluster name from the list to open its details. The details of the cluster are displayed, which can include Cluster performance, Query monitoring, Databases, Datashares, Schedules, Maintenance, and Properties tabs.

  3. Choose the Query monitoring tab for more details.

    For more information, see Viewing query history data.

You can use the Cluster Performance During Query Execution section of the Query view to see cluster metrics during query execution. Doing so helps 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 navigation pane, choose Clusters.

  3. For Cluster, choose the cluster for which you want to view cluster performance during query execution.

  4. Choose the Queries tab.

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

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

  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.