PG_WLM_STATISTICS

PG_WLM_STATISTICS displays information about workload management after the task is complete or the exception has been handled. 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.