GLOBAL_SHARED_MEMORY_DETAIL

GLOBAL_SHARED_MEMORY_DETAIL is used to query the usage of shared memory contexts on all normal nodes in openGauss.

Table 1 GLOBAL_SHARED_MEMORY_DETAIL columns

Name	Type	Description
node_name	name	Node name
contextname	text	Name of the memory context
level	smallint	Level of the memory context
parent	text	Name of the parent memory context
totalsize	bigint	Total size of the shared memory (unit: byte)
freesize	bigint	Remaining size of the shared memory (unit: byte)
usedsize	bigint	Used size of the shared memory (unit: byte)

GLOBAL_SHARED_MEMORY_DETAIL ​