vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0794.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

9.9 KiB
Raw Permalink Blame History

PG_WLM_STATISTICS

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

action

text

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

queryid

bigint

Internal query ID used for statement execution

threadid

bigint

ID of the backend thread
Parent topic: System Views