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.

**Table 1** STATEMENT_WLMSTAT_COMPLEX_RUNTIME columns
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: Ordinary: default attribute of a statement before it is parsed by the database. Simple: simple statement. Complicated: complicated statement. Internal: internal statement of the database.
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: pending: waiting to be executed. running: being executed. finished: finished normally. (If enqueue is set to StoredProc or Transaction, this state indicates that only a part of jobs in the statement has been executed. This state persists until this statement is complete.) aborted: terminated unexpectedly. active: a normal state except for those above. unknown: unknown.
enqueue	text	Queuing status of the statement, including: Global: queuing in the global queue. Respool: queuing in the resource pool queue. CentralQueue: queuing on the CCN. Transaction: queuing in a transaction block. StoredProc: queuing in a stored procedure. None: not in a queue. Forced None: (transaction block statement or stored procedure statement) being forcibly executed because the statement waiting time exceeds the specified value.
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.