PG_SESSION_WLMSTAT¶
PG_SESSION_WLMSTAT displays the corresponding load management information about the task currently executed by the user.
Column | Type | Description |
---|---|---|
datid | OID | OID of the database this backend is connected to |
datname | Name | Name of the database the backend is connected to |
threadid | Bigint | ID of the backend thread |
processid | Integer | Thread PID of the backend |
usesysid | OID | OID of the user who logged in to the backend |
appname | Text | Name of the application that is connected to the backend |
usename | Name | Name of the user logged in to the backend |
priority | Bigint | Priority of Cgroup where the statement is located |
attribute | Text | Statement attributes
|
block_time | Bigint | Pending duration of the statements by now (unit: s) |
elapsed_time | Bigint | Actual execution duration of the statements by now (unit: s) |
total_cpu_time | Bigint | Total CPU usage duration of the statement on the DN in the last period (unit: s) |
cpu_skew_percent | Integer | CPU usage inclination ratio of the statement on the DN in the last period |
statement_mem | Integer | Estimated memory required for statement execution. This column is reserved. |
active_points | Integer | Number of concurrently active points occupied by the statement in the resource pool |
dop_value | Integer | DOP value obtained by the statement from the resource pool |
control_group | Text | Cgroup currently used by the statement |
status | Text | Status of a statement, including:
|
enqueue | Text | Current queuing status of the statements, including:
|
resource_pool | Name | Current resource pool where the statements are located. |
query | Text | Text of this backend's most recent query If state is active, this column shows the executing query. In all other states, it shows the last query that was executed. |
isplana | Bool | In logical cluster mode, indicates whether a statement occupies the resources of other logical clusters. The default value is f, indicating that resources of other logical clusters are not occupied. |
node_group | Text | Logical cluster of the user running the statement |
lane | Text | Fast or slow lane for statement queries.
|