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.
Topics
