SESSION_CPU_RUNTIME
SESSION_CPU_RUNTIME displays load management 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 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. 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 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. |
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.