SESSION_MEMORY_RUNTIME

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

Table 1 SESSION_MEMORY_RUNTIME columns

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
min_peak_memory	integer	Minimum memory peak of the statement across the database nodes, in MB
max_peak_memory	integer	Maximum memory peak of the statement across the database nodes, in MB
spill_info	text	Information about statement spill to the database nodes - None: The statement has not been spilled to disks on the database nodes. - All: The statement has been spilled to disks on the database nodes. - [a:b]: The statement has been spilled to disks on a of b database nodes.
query	text	Statement being executed
node_group	text	Logical MogDB of the user running the statement
top_mem_dn	text	Top N memory usage