- Schema:
WAREHOUSE_LOAD_HISTORY view¶
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
This Organization Usage view can be used to analyze the workload on your warehouse within a specified date range.
- See also:
Columns¶
Note
For the output columns of this view, the query load value is the ratio of the total execution time (in seconds) of all queries in a specific state in an interval by the total time (in seconds) for that interval.
For example, if 276 seconds was the total time for 4 queries in a 5 minute (300 second) interval, then the query load value is 276 / 300 = 0.92.
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
ACCOUNT_LOCATOR |
VARCHAR |
System-defined identifier for an account. |
ACCOUNT_NAME |
VARCHAR |
User-defined identifier for an account. |
START_TIME |
TIMESTAMP_LTZ |
The start of the specified time range (in the UTC time zone) in which the warehouse usage took place. |
END_TIME |
TIMESTAMP_LTZ |
The end of the specified time range (in the UTC time zone) in which the warehouse usage took place. |
WAREHOUSE_ID |
NUMBER |
Internal/system-generated identifier for the warehouse. |
WAREHOUSE_NAME |
TEXT |
Name of the warehouse. |
AVG_RUNNING |
NUMBER(38,9) |
Query load value for queries executed. |
AVG_QUEUED_LOAD |
NUMBER(38,9) |
Query load value for queries queued because the warehouse was overloaded. |
AVG_QUEUED_PROVISIONING |
NUMBER(38,9) |
Query load value for queries queued because the warehouse was being provisioned. |
AVG_BLOCKED |
NUMBER(38,9) |
Query load value for queries blocked by a transaction lock. |
Usage notes¶
Latency for the view may be up to 24 hours.
Load history is shown in 5-minute intervals.