• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PGXC_WLM_WORKLOAD_RECORDS

PGXC_WLM_WORKLOAD_RECORDS

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

Table 1 PGXC_WLM_WORKLOAD_RECORDS columns

Name

Type

Description

node_name

name

Name of the CN where the job is executed

thread_id

bigint

Process ID of the backend

processid

int

lwpid of a thread

timestamp

timestamp with time zone

Time when the statement starts to be executed

username

name

Name of the user logged in to the backend

memory

integer

Memory required by the 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

name

Resource pool to which a job belongs

status

text

Job execution status. Its value can be:

pending

running

finished

aborted

unknown

control_group

name

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