Help Center > > Developer Guide> System Catalogs and System Views> System Views> PGXC_WLM_WORKLOAD_RECORDS

PGXC_WLM_WORKLOAD_RECORDS

Updated at:Jul 15, 2020 GMT+08:00

PGXC_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on CNs. It is accessible only to users with system administrator rights. 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

Process ID of the backend

processid

integer

lwpid of a thread

timestamp

bigint

Time when a statement starts to be executed

username

name

Name of a user logged in to the backend

memory

integer

Memory required by a statement

active_points

integer

Number of resources consumed by a statement in a resource pool

max_points

integer

Maximum number of resources in a resource pool

priority

integer

Priority of a job

resource_pool

text

Resource pool to which a job belongs

status

text

Job execution status. Its value can be:

pending

running

finished

aborted

unknown

control_group

text

Cgroups used by a job

enqueue

text

Queue that a job is in. Its value can be:

GLOBAL: global queue

RESPOOL: resource pool queue

ACTIVE: not in a queue

query

text

Statement that is being executed

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel