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

GLOBAL_WLM_WORKLOAD_RUNTIME

Displays the status of jobs executed by the current user on CNs, as described in Table 1. This view is accessible only to users with the monadmin permission.

Table 1 GLOBAL_WAL_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

LWP ID of the 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

Maximum number of resources 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

name

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.