© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
A. CarruthersTuning the Snowflake Data Cloudhttps://doi.org/10.1007/979-8-8688-0379-6_3

3. The Query Profiler

Andrew Carruthers1  
(1)
Birmingham, UK
 

In Chapter 2, I showed how the query optimizer processes a SQL statement to produce a physical query plan. You will investigate how the query profiler operates by executing a query plan and generating execution statistics that expose various metrics.

This chapter initially focuses on the visual aspects of query profiling and later focuses on remediating issues.

The hands-on examples utilize TPC-H data supplied by Snowflake; you can find additional information about this data set at https://docs.snowflake.com/en/user-guide/sample-data-tpch ...

Get Tuning the Snowflake Data Cloud: Optimizing Your Data Platform to Minimize Cost and Maximize Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.