Analyzing the query summary - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Analyzing the query summary

To get execution steps and statistics in more detail than in the query plan that EXPLAIN produces, use the SVL_QUERY_SUMMARY and SVL_QUERY_REPORT system views.

SVL_QUERY_SUMMARY provides query statistics by stream. You can use the information it provides to identify issues with expensive steps, long-running steps, and steps that write to disk.

The SVL_QUERY_REPORT system view enables you to see information similar to that for SVL_QUERY_SUMMARY, only by compute node slice rather than by stream. You can use the slice-level information for detecting uneven data distribution across the cluster (also known as data distribution skew), which forces some nodes to do more work than others and impairs query performance.