SESSION_CPU_RUNTIME
SESSION_CPU_RUNTIME displays information about CPU usage of ongoing complex jobs executed by the current user, as described in Table 1.
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 |
Backend thread ID. |
start_time |
timestamp with time zone |
Time when the statement execution starts. 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 all DNs (unit: ms). |
max_cpu_time |
bigint |
Maximum CPU time of the statement across all DNs (unit: ms). |
total_cpu_time |
bigint |
Total CPU time of the statement across all DNs (unit: ms). |
query |
text |
Statement being executed. |
node_group |
text |
Node group of the user to which the statement belongs. |
top_cpu_dn |
text |
Top N CPU usage. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.