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
|
Thread ID of the backend
|
processid
|
integer
|
Process ID of the backend
|
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
|
Attributes of the statement: - 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 (unit: s)
|
elapsed_time
|
bigint
|
Actual execution duration of the statement by now (unit: s)
|
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
|
statement_mem 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
|
Unsupported currently
|
status
|
text
|
Unsupported 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: being in a transaction block
- StoredProc: being in a stored procedure
- None: not in the queue
- Forced None: being forcibly executed (transaction block statement or stored procedure statement are) because the statement waiting time exceeds the specified value
|
resource_pool
|
name
|
Current resource pool where the statements are located
|
query
|
text
|
Latest query at the backend. If state is active, this column shows the ongoing query. In all other states, it shows the last query that was executed.
|
is_plana
|
boolean
|
Whether the execution of the statement occupies resources of other logical openGauss in logical openGauss mode. The default value is f (does not occupy resources).
|
node_group
|
text
|
Logical openGauss of the user running the statement
|