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. |
