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 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: 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 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: 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.
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.