GLOBAL_WLM_WORKLOAD_RUNTIME

pending: blocked status
running: running status
finished: final status
aborted: termination status
unknown: unknown status

GLOBAL_WAL_WORKLOAD_RUNTIME displays the status of jobs executed by the current user on CNs. This view is accessible only to users with system administrator permissions.

**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	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	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