PG_WLM_STATISTICS

pending: waiting to be executed.
running: being executed.
finished: finished normally.
abort: terminated unexpectedly.

PG_WLM_STATISTICS displays information about workload management after the task is complete or the exception has been handled. The current feature is a lab feature. Contact Huawei technical support before using it. Only the user with sysadmin permission can query this view.

**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 database instance when the statement is executed for exception handling.
qualification_time	bigint	Period when the statement checks the skew.
cpu_skew_percent	integer	CPU usage skew on the database instance 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 statement are executed for exception handling, including: pending: waiting to be executed. running: being executed. finished: finished normally. abort: terminated unexpectedly.
action	text	Actions when statements are executed for exception handling, including: abort: terminating the operation. adjust: executing the Cgroup adjustment operations. Currently, you can only perform the demotion operation. finish: finished normally.