Updated on 2024-05-07 GMT+08:00

WLM_WORKLOAD_RUNTIME

WLM_WORKLOAD_RUNTIME displays the status of jobs being executed by the current user on the current CN.

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 execution starts.

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.