Updated on 2023-10-23 GMT+08:00

GS_SESSION_CPU_STATISTICS

GS_SESSION_CPU_STATISTICS shows load management information about CPU usage of ongoing complex jobs executed by the current user. (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.) Only the user with sysadmin permission can query this view.

Table 1 GS_SESSION_CPU_STATISTICS columns

Name

Type

Description

datid

oid

OID of the database that the backend is connected to

usename

name

Name of the user logged in to the backend

pid

bigint

Process ID of the backend

start_time

timestamp with time zone

Time when the statement starts to run

min_cpu_time

bigint

Minimum CPU time of the statement across all DNs, in ms

max_cpu_time

bigint

Maximum CPU time of the statement across all DNs, in ms

total_cpu_time

bigint

Total CPU time of the statement across all DNs, in ms

query

text

Statement being executed

node_group

text

Logical cluster of the user running the statement. (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)

top_cpu_dn

text

Top N CPU usage