Amazon Redshift Podręcznik Użytkownika Pobierz pdf (Strona 195)

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

1 2 ... 190 191 192 193 194 195 196 197 198 199 200 ... 254 255

Brak uwag

Amazon Redshift Podręcznik Użytkownika Strona 195