- 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.
Organization-level columns
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
ACCOUNT_LOCATOR |
VARCHAR |
System-generated identifier for the account. |
ACCOUNT_NAME |
VARCHAR |
User-defined identifier for the account. |
Additional columns
Column Name |
Data Type |
Description |
|---|---|---|
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.