GS_WLM_WORKLOAD_RECORDS

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

GS_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on each CN. Only the user with sysadmin permission can query this view.

**Table 1** GS_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	PID of the backend thread
time_stamp	bigint	Time when the statement starts to be 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 that can be consumed by the statement in a resource pool
priority	integer	Priority of the job The value must be within the integer range. 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	Logical cluster name (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)