Updated on 2024-05-07 GMT+08:00

PG_SHARED_MEMORY_DETAIL

PG_SHARED_MEMORY_DETAIL displays 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.