PG_WLM_STATISTICS¶
PG_WLM_STATISTICS displays information about workload management after the task is complete or the exception has been handled. This view has been discarded in 8.1.2. You can use PGXC_WLM_SESSION_INFO to view load management records of completed jobs executed on all CNs.
Column | Type | Description |
---|---|---|
statement | Text | Statement executed for exception handling |
block_time | Bigint | Block time before the statement is executed |
elapsed_time | Bigint | Elapsed time when the statement is executed |
total_cpu_time | Bigint | Total time used by the CPU on the DN when the statement is executed for exception handling |
qualification_time | Bigint | Period when the statement checks the inclination ratio |
cpu_skew_percent | Integer | CPU usage skew on the DN when the statement is executed for exception handling |
control_group | Text | Cgroup used when the statement is executed for exception handling |
status | Text | Statement status after it is executed for exception handling
|
action | Text | Actions when statements are executed for exception handling
|
queryid | Bigint | Internal query ID used for statement execution |
threadid | Bigint | ID of the backend thread |