Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ Schemas/ DBE_PERF Schema/ Session and Thread/ SESSION_CPU_RUNTIME
Updated on 2025-07-15 GMT+08:00
View PDF
Share

SESSION_CPU_RUNTIME

SESSION_CPU_RUNTIME displays 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

Backend thread ID.

start_time

timestamp with time zone

Time when the statement execution starts.

min_cpu_time

bigint

Minimum CPU time of the statement across all DNs (unit: ms).

max_cpu_time

bigint

Maximum CPU time of the statement across all DNs (unit: ms).

total_cpu_time

bigint

Total CPU time of the statement across all DNs (unit: ms).

query

text

Statement being executed.

node_group

text

Node group of the user to which the statement belongs.

top_cpu_dn

text

Top N CPU usage.
Parent topic: Session and Thread