STV_WLM_QUERY_TASK_STATE
Contains the current state of service class query tasks.
STV_WLM_QUERY_TASK_STATE is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.
Table columns
Column name | Data type | Description |
---|---|---|
service_class | integer | ID for the service class. For a list of service class IDs, see WLM service class IDs. |
task | integer | ID used to track a query through the workload manager. Can be associated with multiple query IDs. If a query is restarted, the query is assigned a new query ID but not a new task ID. |
query | integer | Query ID. If a query is restarted, the query is assigned a new query ID but not a new task ID. |
slot_count | integer | Number of WLM query slots. |
start_time | timestamp | Time that the query began executing. |
exec_time | bigint | Number of microseconds that the query has been executing. |
Sample query
The following query displays the current state of queries in service classes greater than 4. For a list of service class IDs, see WLM service class IDs.
select * from stv_wlm_query_task_state where service_class > 4;
This query returns the following sample output:
service_class | task | query | start_time | exec_time --------------+------+-------+----------------------------+----------- 5 | 466 | 491 | 2010-10-06 13:29:23.063787 | 357618748 (1 row)