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.
|
openGauss 2024-09-07 01:01:32