メニュー
Amazon Redshift
管理ガイド (API Version 2012-12-01)

クエリ実行中のクラスターパフォーマンスの表示

[Query] ビューの [Cluster Performance During Query Execution] セクションを使用してクエリ実行中のクラスターメトリクスを表示し、パフォーマンスが低いクエリを識別したり、ボトルネックのクエリを探したり、ワークロードに対してクラスターのサイズを変更する必要があるかどうかを判断したりできます。

To view cluster metrics during query execution

  1. AWS マネジメントコンソールにサインインし、Amazon Redshift コンソール(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.

    ヒント

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