SESSION_CPU_RUNTIME
SESSION_CPU_RUNTIME displays load management 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 | Thread ID of the backend |
start_time | timestamp with time zone | Time when the statement starts to be executed |
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 |
node_group | text | Logical openGauss of the user running the statement |
top_cpu_dn | text | Top N CPU usage |
openGauss 2025-04-28 22:42:03