HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

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 that the 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 Unsupported currently
top_mem_dn text Memory usage
Copyright © 2011-2024 www.enmotech.com All rights reserved.