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

GS_WLM_WORKLOAD_RECORDS

Updated at: Dec 30, 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