Amazon Redshift
Cluster Management Guide

Viewing Cluster Performance Data

By using cluster metrics in Amazon Redshift, you can do the following common performance tasks:

  • Determine if cluster metrics are abnormal over a specified time range and, if so, identify the queries responsible for the performance hit.

  • Check if historical or current queries are impacting cluster performance. If you identify a problematic query, you can view details about it including the cluster performance during the query's execution. You can use this information in diagnosing why the query was slow and what can be done to improve its performance.

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.

New Console

To view performance data

  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 name of a cluster from the list to open its details. The details of the cluster are displayed, including Query monitoring, Cluster performance, Maintenance and monitoring, Backup, Properties, and Schedule tabs.

  3. Choose the Cluster performance tab for performance information including the following:

    • CPU utilization

    • Percentage disk space used

    • Database connections

    • Health status

    • Query duration

    • Query throughput

    • Concurrency scaling usage

    Many more metrics are available. To see the available metrics and choose which are displayed, choose the Preferences icon.

Original Console

The default cluster view shows all nodes graphed together, an Average statistic, and data for the last hour. You can change this view as needed. Some metrics, such as HealthStatus, are only applicable for the leader node while others, such as WriteOps, are only applicable for compute nodes. Switching the node display mode resets all filters.

To view cluster 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 Performance tab.

    By default, the performance view displays cluster performance over the past hour. If you need to fine-tune the view, you have filters that you can use as described in the following table.

    To Do This Use This Filter
    Change the time range for which data is displayed Select a time range from the Time Range list. By default, the last hour is shown.
    Change the period for which data is displayed

    Select a period from the Period list. By default, a five-minute period is shown. Use a period smaller than five minutes if you need more detail when investigating a metric (drilling in) and displaying metrics over a small time period, for example ten minutes. Similarly, use a period greater than five minutes when viewing metrics over a large period of time, for example days.

    Change the statistic that is displayed for metrics

    Select a statistic from the Statistic list. By default, the Average statistic is used.

    Change what metrics are shown, all or a specific metric

    Choose a metric from the Metrics list. By default, all metrics are shown.

    Change whether node metrics are displayed separately or together on the same graph

    Choose Nodes. By default, node data for a given metric is shown on a combined graph. If you choose to display node data on separate graphs, you can additionally show or hide individual nodes.

Cluster Metrics: Examples

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.

New Console

Choose the DASHBOARD page and find the Cluster overview section to see graphs of metrics about your clusters, such as the following:

  • Number of queries

  • Database connections

  • Disk space used

  • CPU utilization

To see graphs of metrics about your cluster, choose the CLUSTER page, choose a cluster name, and then choose the Cluster performance tab. For example, you might view a graph for Network receive throughput.

Original Console

The following example shows CPUUtilization and NetworkReceiveThroughput metrics for a single node cluster. In this case, the graphs for cluster metrics show one line marked as Shared because the leader and compute node are combined. The example shows that multiple queries were run in the time period shown. On the Queries graph, the cursor is positioned over the query running at the peak values of the two metrics and the Query ID is displayed on the right. You can then choose the Query ID to find out more about the query running.

The following example shows the NetworkReceiveThroughput for a cluster with two nodes. It shows a line for the leader and two compute nodes. The leader node metrics appear as flat and aren't of interest because data is only loaded on the compute nodes. The example shows that one long query ran in the time period shown. On the Queries graph, the cursor is positioned over the long running query and the Query ID is displayed on the right. You can then choose the Query ID to find out more about the query running. The NetworkReceiveThroughput value is displayed during the query execution.