Updated on 2024-09-30 GMT+08:00

GS_SESSION_CPU_STATISTICS

GS_SESSION_CPU_STATISTICS displays load management information about CPU usage of ongoing complex jobs executed by the current user.

Table 1 GS_SESSION_CPU_STATISTICS columns

Name

Type

Description

datid

oid

OID of the database the backend is connected to.

usename

name

Username logged in to the backend.

pid

bigint

Backend thread ID.

start_time

timestamp with time zone

Start time of statement execution.

min_cpu_time

bigint

Minimum CPU time of a statement across all DNs. The unit is ms.

max_cpu_time

bigint

Maximum CPU time of a statement across all DNs. The unit is ms.

total_cpu_time

bigint

Total CPU time of a statement across all DNs. The unit is ms.

query

text

Statement currently being executed.

node_group

text

Logical cluster of the user running the statement.