SESSION_CPU_RUNTIME
SESSION_CPU_RUNTIME displays load management information about CPU usage of ongoing complex jobs executed by the current user.
Table 1 SESSION_CPU_RUNTIME columns
Name
|
Type
|
Description
|
|---|
datid
|
oid
|
OID of the database that this backend is connected to
|
usename
|
name
|
Name of the user logged in to the backend
|
pid
|
bigint
|
Thread ID of the backend
|
start_time
|
timestamp with time zone
|
Time when the statement starts to be executed
|
min_cpu_time
|
bigint
|
Minimum CPU time of the statement across the database nodes, in ms
|
max_cpu_time
|
bigint
|
Maximum CPU time of the statement across the database nodes, in ms
|
total_cpu_time
|
bigint
|
Total CPU time of the statement across the database nodes, in ms
|
query
|
text
|
Statement being executed
|
node_group
|
text
|
Logical openGauss of the user running the statement
|
top_cpu_dn
|
text
|
Top N CPU usage
|