User guide

For more information about the difference between the explain plan and system views and logs, go to
Mapping the Query Plan to System Views in the Amazon Redshift Database Developer Guide in the
Amazon Redshift Database Developer Guide.
Viewing Query Execution Details Using the Console
Use the following procedure to look at the details of query execution.
To view query execution details
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 query execution details.
4. Click the Queries tab, and open the query for which you want to view performance data.
5. Expand the Query Execution Details section and do the following:
a. On the Plan tab, review the explain plan for the query. If you find that your explain plan differs
from the actual query execution on the Actual tab, you might need to run ANALYZE to update
statistics or perform other maintenance on the database to optimize the queries you run. For more
information about query optimization, see Tuning Query Performance in the Amazon Redshift
Database Developer Guide.
b. On the Actual tab, review the performance data associated with each of the plan nodes in the
query execution.You can click an individual plan node in the hierarchy to view performance data
associated with that specific plan node.This data will include both the estimated and actual
performance data.
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.
API Version 2012-12-01
192
Amazon Redshift Management Guide
Viewing Query Performance Data