Updated on 2023-10-23 GMT+08:00

WLM_WORKLOAD_RUNTIME

WLM_WORKLOAD_RUNTIME displays the status of job executed by the current user on CNs.

Table 1 WLM_WORKLOAD_RUNTIME columns

Name

Type

Description

node_name

text

Name of the CN where a job is executed

thread_id

bigint

Backend thread ID

processid

integer

PID of the backend thread

time_stamp

bigint

Time when the statement starts to be executed

username

name

Name of the user logged in to the backend

memory

integer

Memory required by the statement

active_points

integer

Number of resources consumed by the statement in the resource pool

max_points

integer

Number of resources consumed by the statement in the resource pool

priority

integer

Job priority

resource_pool

text

Resource pool to which the job belongs

status

text

Job execution status. Its value can be:
  • pending: blocked status
  • running: running status
  • finished: final status
  • aborted: termination status
  • unknown: unknown status

control_group

text

Cgroups used by the job

enqueue

text

Queue that the job is in. Its value can be:
  • GLOBAL: global queue
  • RESPOOL: resource pool queue
  • ACTIVE: not in a queue

query

text

Statement being executed

node_group

text

Logical cluster name (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)