GS_SESSION_MEMORY_STATISTICS

GS_SESSION_MEMORY_STATISTICS displays load management information about memory usage of ongoing complex jobs executed by the current user. (The current feature is a lab feature. Contact Huawei technical support before using it.) Only the user with sysadmin permission can query this view.

**Table 1** GS_SESSION_MEMORY_STATISTICS columns
Name	Type	Description
datid	oid	OID of the database that the backend is connected to
usename	name	Name of the user logged in to the backend
pid	bigint	Process ID of the backend
start_time	timestamp with time zone	Time when the statement starts to run
min_peak_memory	integer	Minimum memory peak of the statement across all DNs, in MB
max_peak_memory	integer	Maximum memory peak of the statement across all DNs, in MB
spill_info	text	Statement spill information on all DNs: None: No data is spilled to disks on all DNs. All: Data is spilled to disks on all DNs. [a:b]: The statement has been spilled to disks on a of b DNs.
query	text	Statement being executed
node_group	text	Logical cluster of the user running the statement. (The current feature is a lab feature. Contact Huawei technical support before using it.)
top_mem_dn	text	Top N memory usage