PGXC_WLM_WORKLOAD_RECORDS

PGXC_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on CNs. Only the system administrator or the preset role gs_role_read_all_stats can access this view. This view is available only when enable_dynamic_workload is set to on.

**Table 1** PGXC_WLM_WORKLOAD_RECORDS columns
Name	Type	Description
node_name	text	Name of the CN where the job is executed.
thread_id	bigint	ID of the backend thread.
processid	integer	lwpid of the thread.
timestamp	bigint	Start time of statement execution.
username	name	Username logged in to the backend.
memory	integer	Memory required for the statement.
active_points	integer	Number of resources consumed by the statement on the resource pool.
max_points	integer	Maximum number of resources in the resource pool.
priority	integer	Priority of a job.
resource_pool	text	Resource pool where a job is.
status	text	Job execution status. The options are: pending running finished aborted unknown
control_group	text	Cgroups used by a job.
enqueue	text	Queue for the job, including: GLOBAL: global queue. RESPOOL: resource pool queue. ACTIVE: not queued.
query	text	Statement currently being executed.