PG_WLM_STATISTICS

Updated on 2023-10-31 GMT+08:00

View PDF

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.

**Table 1** PG_WLM_STATISTICS columns
Name	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 pending: The statement is waiting to be executed. running: The statement is being executed. finished: The execution is finished normally. abort: The execution is unexpectedly terminated.
action	text	Actions when statements are executed for exception handling abort indicates terminating the operation. adjust indicates executing the Cgroup adjustment operations. Currently, you can only perform the demotion operation. finish indicates that the operation is normally finished.
queryid	bigint	Internal query ID used for statement execution
threadid	bigint	ID of the backend thread