GS_SESSION_MEMORY_STATISTICS¶
GS_SESSION_MEMORY_STATISTICS displays load management information about memory usage of ongoing complex jobs executed by the current user.
Name | Type | Description |
---|---|---|
datid | oid | OID of the database the backend is connected to |
usename | name | Name of the user logged in to the backend |
pid | bigint | ID of the backend thread |
start_time | timestamp with time zone | Time when the statement starts to be executed |
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 | Statement spill information on all DNs.
|
query | text | Statement that is being executed |
node_group | text | Logical cluster of the user running the statement |