PGXC_WLM_WORKLOAD_RECORDS

GLOBAL: global queue
RESPOOL: resource pool queue
Active: not in a queue

PGXC_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on CNs. Only the sysadmin user can query this view.

**Table 1** PGXC_WLM_WORKLOAD_RECORDS columns
Name	Type	Description
node_name	text	Name of the CN where a job is executed
thread_id	bigint	Process ID of the backend
processid	integer	Lightweight process ID of a thread
time_stamp	bigint	Time when the statement starts to run
username	name	Name of the user logged in to the backend
memory	integer	Memory required by the statement
active_points	integer	Number of resource points consumed by the statement in a resource pool
max_points	integer	Maximum number of resource points in a resource pool
priority	integer	Priority of a job. A larger value indicates a higher priority.
resource_pool	text	Resource pool to which the job belongs
status	text	Job execution status. The value must be one of the following: pending running finished aborted unknown
control_group	text	Cgroups used by the job
enqueue	text	Queue that the job is in. The value must be one of the following: GLOBAL: global queue RESPOOL: resource pool queue Active: not in a queue
query	text	Statement being executed
node_group	text	Node group to which the statement belongs