GS_SESSION_MEMORY_STATISTICS
GS_SESSION_MEMORY_STATISTICS displays load management information about memory usage of ongoing complex jobs executed by the current user.
| Column | Type | Description |
|---|---|---|
| datid | OID | OID of the database the backend is connected to. |
| usename | Name | Username logged in to the backend. |
| pid | Bigint | Backend thread ID. |
| start_time | Timestamp with time zone | Start time of statement execution. |
| min_peak_memory | Integer | Minimum memory peak of a statement across all DNs, in MB |
| max_peak_memory | Integer | Maximum memory peak of a statement across all DNs, in MB |
| spill_info | Text | Spill information for the statement on all DNs. The options are: None: The statement has not been spilled to disks on any DNs. All: The statement has been spilled to disks on all DNs. [a:b]: The statement has been spilled to disks on a of b DNs. |
| query | Text | Statement currently being executed. |
| node_group | Text | Logical cluster of the user running the statement. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
