GS_SESSION_MEMORY_STATISTICS

GS_SESSION_MEMORY_STATISTICS displays load management information about memory usage of ongoing complex jobs executed by the current user.

**Table 1** GS_SESSION_MEMORY_STATISTICS columns
Name	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.