Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ Session/Thread/ GLOBAL_SESSION_MEMORY_DETAIL

Updated on 2024-06-03 GMT+08:00

View PDF

GLOBAL_SESSION_MEMORY_DETAIL

Collects statistics about thread memory usage on each node by MemoryContext, as shown in Table 1.

**Table 1** GLOBAL_SESSION_MEMORY_DETAIL columns
Name	Type	Description
node_name	name	Node name.
sessid	text	Thread start time and ID.
sesstype	text	Thread name.
contextname	text	Name of the memory context.
level	smallint	Level of memory context importance.
parent	text	Name of the parent memory context.
totalsize	bigint	Size of the allocated memory (unit: byte).
freesize	bigint	Size of the idle memory (unit: byte).
usedsize	bigint	Size of the used memory (unit: byte).