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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot