Back to Starrocks

warehouse_queries

docs/en/sql-reference/information_schema/warehouse_queries.md

4.1.01.4 KB
Original Source

warehouse_queries

warehouse_queries provides information about queries running on each warehouse.

The following fields are provided in warehouse_queries:

FieldDescription
WAREHOUSE_IDID of the warehouse.
WAREHOUSE_NAMEName of the warehouse.
QUERY_IDID of the query.
STATEState of the query (e.g., PENDING, RUNNING, FINISHED).
EST_COSTS_SLOTSEstimated cost slots for the query.
ALLOCATE_SLOTSAllocated slots for the query.
QUEUED_WAIT_SECONDSTime in seconds the query waited in the queue.
QUERYThe SQL query string.
QUERY_START_TIMEStart time of the query.
QUERY_END_TIMEEnd time of the query.
QUERY_DURATIONDuration of the query.
EXTRA_MESSAGEExtra message.