GS_WLM_WORKLOAD_RECORDS
GS_WLM_WORKLOAD_RECORDS displays the status of job executed by the current user on CNs.
| 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:
|
| 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 |
| node_group | text | Name of a logical cluster |
Last Article: GS_WLM_SESSION_STATISTICS
Next Article: PGXC_WORKLOAD_SQL_COUNT
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.