Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ System Catalogs and System Views/ System Views/ GS_SESSION_CPU_STATISTICS
Updated on 2024-09-02 GMT+08:00
View PDF
Share

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.
Parent topic: System Views