PG_WLM_STATISTICS

PG_WLM_STATISTICS shows information about workload management after the task is complete or the exception has been handled.

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 node 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 node when the statement is executed for exception handling
control_group	text	Unsupported currently
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