Updated on 2024-06-03 GMT+08:00

WLM_WORKLOAD_RUNTIME

WLM_WORKLOAD_RUNTIME displays the status of jobs being executed by the current user on the current CN, as described in Table 1.

Table 1 WLM_WORKLOAD_RUNTIME columns

Name

Type

Description

node_name

text

Name of the CN where the 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

Username for logging 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.
  • running: running.
  • finished: ended.
  • aborted: aborted.
  • unknown: unknown.

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.