SESSION_MEMORY_RUNTIME

SESSION_MEMORY_RUNTIME displays 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	Backend thread ID.
start_time	timestamp with time zone	Time when the statement execution starts. For a stored procedure, function, or package, the first query time is queried and does not change with the running of statements in the stored procedure.
min_peak_memory	integer	Minimum peak memory of the statement among all DNs (unit: MB).
max_peak_memory	integer	Maximum peak memory of the statement among all DNs (unit: 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	Node group of the user to which the statement belongs.
top_mem_dn	text	Top N memory usage.

Parent topic: Session and Thread

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.