The user is referring to this in particular:
Query History: It keeps a record of all queries executed in your Snowflake account. This allows you to analyze the performance of individual queries, including their execution time, number of rows processed, etc. However, it does not provide specific information on the impact of query queuing on virtual warehouse performance.
WAREHOUSE_LOAD_HISTORY: This system view provides specific information on the usage of the virtual warehouse, including the wait times of queries in the queue. This allows you to evaluate the impact of query queuing on virtual warehouse performance by providing data on warehouse load and usage.
So, if you want to assess the impact of query queuing on virtual warehouse performance, the WAREHOUSE_LOAD_HISTORY view would be more appropriate. If you want to examine the performance of individual queries as a whole, then Query History would be more relevant
Query history is to understand queue times at query level.
Warehouse load history provides this at Warehouse level.
"AVG_QUEUED_LOAD - Query load value for queries queued because the warehouse was overloaded."
Since question asks for Warehouse, Answer is C here.
QUEUED_OVERLOAD_TIME
NUMBER
Time (in milliseconds) spent in the warehouse queue, due to the warehouse being overloaded by the current query workload.
https://docs.snowflake.com/en/sql-reference/account-usage/query_history
Even C seems to be correct. But, the Query History provides more information than the Load history.
AVG_QUEUED_LOAD.
Query load value for queries queued because the warehouse was overloaded.
https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_load_history
WAREHOUSE_LOAD_HISTORY - C
AVG_RUNNING – Average number of queries executed.
AVG_QUEUE_LOAD – Average number of queries queued because the warehouse was overloaded.
AVG_QUEUE_PROVISION – Average number of queries queued because the warehouse was being provisioned.
AVG_BLOCKED – Average number of queries blocked by a transaction lock.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
bor4un
3 months agoLematthew31
5 months, 3 weeks agofellpond
7 months agoValcon_doo
11 months agobor4un
3 months ago[Removed]
11 months, 3 weeks ago[Removed]
1 year agokayuhanbiduk
1 year agoRajivnb
1 year agoRajivnb
1 year agoAmitsnowflake
1 year agoHeetec
1 year agoromega2
1 year agopvskbrod
1 year, 1 month agopvskbrod
1 year, 1 month agohappykeieiekek
1 year, 2 months agoMultiCloudIronMan
1 year, 3 months ago