Updated on 2025-05-29 GMT+08:00

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.