PGXC_SESSION_WLMSTAT¶
PGXC_SESSION_WLMSTAT displays load management information about ongoing jobs executed on each CN in the current cluster.
Column | Type | Description |
---|---|---|
nodename | Name | Node name. |
datid | OID | OID of the database the backend is connected to. |
datname | Name | Name of the database the backend is connected to. |
threadid | Bigint | ID of the backend thread. |
processid | Integer | PID of a backend thread |
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.
|