HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

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
Copyright © 2011-2024 www.enmotech.com All rights reserved.