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

SESSION_CPU_RUNTIME

SESSION_CPU_RUNTIME displays load management information about CPU usage of ongoing complex jobs executed by the current user, as described in Table 1.

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. For a stored procedure, function, or package, the first query time is queried and does not change with the running of statements in the stored procedure.

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.

top_cpu_dn

text

Top N CPU usage.