Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_WLM_STATISTICS

PG_WLM_STATISTICS

Updated at:Jul 15, 2020 GMT+08:00

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 indicates that the statement is waiting to be executed.
  • running: The statement is being executed.
  • finished: The execution is finished normally.
  • aborted indicates that the execution is unexpectedly terminated.

action

text

Actions when statement 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel