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

GS_WLM_WORKLOAD_RECORDS

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

GS_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on CNs.

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

ID of a backend process

processid

integer

PID of a backend thread

time_stamp

name

Time when a statement starts to be executed

username

interger

Name of a user logged in to the backend

memory

interger

Memory required by a statement

active_points

interger

Number of resources consumed by a statement in a resource pool

priority

interger

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

node_group

text

Name of a logical cluster

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