Lu, Huayi
a24ca60074
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
11 KiB
PGXC_WLM_WORKLOAD_RECORDS
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.
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 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 |