PG_WLM_STATISTICS

pending: statement waiting to be executed
running: statement being executed
finished: execution normally finished
aborted: execution unexpectedly terminated

PG_WLM_STATISTICS displays 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 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: statement waiting to be executed running: statement being executed finished: execution normally finished aborted: execution unexpectedly terminated
action	text	Actions when statement are executed for exception handling abort: terminating the operation adjust: executing the Cgroup adjustment operations. Currently, you can only perform the demotion operation. finish: operation normally finished

Parent topic: System Views

Last Article: PG_VIEWS

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center