PGXC_WLM_WORKLOAD_RECORDS¶
PGXC_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on CNs. Only the system administrator or the preset role gs_role_read_all_stats can access this view. This view is available only when enable_dynamic_workload is set to on.
Name | Type | Description |
---|---|---|
node_name | text | Name of the CN where the job is executed |
thread_id | bigint | ID of the backend thread |
processid | integer | lwpid of a thread |
timestamp | bigint | Time when a statement starts to be executed |
username | name | Name of the user logging 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 of a job |
status | text | Job execution status. Its value can be:
|
control_group | text | Cgroups used by a job |
enqueue | text | Queue that a job is in. Its value can be:
|
query | text | Statement that is being executed |