WORKLOAD_
This system table shows the current list of queries for which the Workload Management system cannot reserve resources for an execution and therefore has put them into the waiting queue.
It provides a detailed explanation of which resource is lacking (required > (limit - used)), and therefore why the query is queued.
|
Column Name |
Descriptiom |
|---|---|
|
|
Text of query |
|
|
The time when the query was submitted for execution |
|
|
How many system threads are required for the query execution |
|
|
Total number of threads allowed at the time of query submission |
|
|
Total number of used threads at the time of query submission |
|
|
How many system connections are required for the query execution |
|
|
Total number of connections allowed at the time of query submission |
|
|
Total number of used connections at the time of query submission |
|
|
How much memory (in MB) is required for the query execution |
|
|
Total amount of memory allowed at the time of query submission |
|
|
Total amount of used memory at the time of query submission |
|
|
Medium, Large (Small queries are never queued) |
|
|
Small, Medium, Large |
Last modified: April 28, 2023