Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ GS_SHARED_MEMORY_DETAIL
Updated on 2025-08-19 GMT+08:00
View PDF

GS_SHARED_MEMORY_DETAIL

Queries the usage information about shared memory contexts on the current node. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and the empty list is returned if this view is accessed in a PDB.

Table 1 GS_SHARED_MEMORY_DETAIL columns

Name

Type

Description

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).
Parent topic: Other System Views