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 this backend is connected to. |
datname |
name |
Name of the database that the backend is connected to. |
threadid |
bigint |
Backend thread ID. |
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 |
Username for logging 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 DN in the last period, in seconds. |
cpu_skew_percent |
integer |
CPU usage inclination ratio of the statement on the DN 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 |
Cgroup currently used by the statement. |
status |
text |
Statement status, which can be:
|
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. |
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