User guide

Analyzing Query Execution
The Query Execution Details section of the Query view provides information about the way the query
was processed.This section combines data from SVL_QUERY_REPORT, STL_EXPLAIN, and other
system views and tables.
The Query Execution Details section has two tabs:
• Plan. This tab shows the explain plan for the query that is displayed.
• Actual.This tab shows the actual steps and statistics for the query that was executed.This information
displays in a textual hierarchy and a visual chart.You can hover your cursor over any bar in the chart
to see the Avg and Max statistics for the related step, as shown following.
API Version 2012-12-01
189
Amazon Redshift Management Guide
Viewing Query Performance Data