Question

A data engineer is troubleshooting a slow-running analytical query. She opens the Query Profile in Snowsight and notices that one operator node accounts for 78% of the total execution time. She wants to systematically identify and address the single biggest performance bottleneck in the query. Which element of the Query Profile is the MOST direct indicator she should use to locate that bottleneck?

Accepted Answer

The 'Most Expensive Nodes' list, which ranks operator nodes by their fraction of total execution time

Answer

The 'Bytes scanned' statistic in the overview panel for the entire query

Answer

The 'Total Statistics' section showing the number of partitions in the source tables

Answer

The compilation time reported at the top of the profile