STATEMENT_WLMSTAT_COMPLEX_RUNTIME
STATEMENT_WLMSTAT_COMPLEX_RUNTIME displays load management information about ongoing jobs executed by the current user, as described in Table 1.
| Name | Type | Description |
|---|---|---|
| datid | oid | OID of the database that the backend is connected to. |
| datname | name | Name of the database that the backend is connected to. |
| threadid | bigint | ID of the backend thread. |
| processid | integer | PID of the backend thread. |
| usesysid | oid | OID of the user logged in to the backend. |
| appname | text | Name of the application 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 attribute:
|
| block_time | bigint | Pending duration of the statement by now, in seconds. |
| elapsed_time | bigint | Actual execution duration of the statement by now, in seconds. |
| total_cpu_time | bigint | Total CPU usage duration of the statement on the database nodes in the last period (unit: s). |
| cpu_skew_percent | integer | CPU usage skew percentage of the statement on the database nodes in the last period. |
| statement_mem | integer | Memory used for executing the statement (reserved column). |
| 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 | Not supported currently. |
| status | text | Not supported currently. |
| enqueue | text | Queuing status of the statement, including:
|
| resource_pool | name | Resource pool where the statement is located. |
| query | text | Latest query at the backend. If state is active, this column shows the executing query. In any other state, it shows the last query that was executed. |
| is_plana | boolean | Specifies whether a statement occupies resources of other logical databases for execution in logical database mode. The default value is f (no). |
| node_group | text | Logical database of the user running the statement. |
