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

PG_SHARED_MEMORY_DETAIL

PG_SHARED_MEMORY_DETAIL queries usage information about all the shared memory contexts.

Table 1 PG_SHARED_MEMORY_DETAIL columns

Name

Type

Description

contextname

text

Name of the memory context

level

smallint

Hierarchy of the memory context

parent

text

Name of the parent memory context

totalsize

bigint

Total size of the shared memory, in bytes

freesize

bigint

Remaining size of the shared memory, in bytes

usedsize

bigint

Used size of the shared memory, in bytes