pg_shmem_allocations view shows allocations made from the server's main shared memory segment. This includes both memory allocated by postgres itself and memory allocated by extensions using the mechanisms detailed in Section 35.10.10.
Note that this view does not include memory allocated using the dynamic shared memory infrastructure.
The name of the shared memory allocation. NULL for unused memory and
The offset at which the allocation starts. NULL for anonymous allocations, since details related to them are not known.
Size of the allocation
Size of the allocation including padding. For anonymous allocations, no information about padding is available, so the
Anonymous allocations are allocations that have been made with
ShmemAlloc() directly, rather than via
By default, the
pg_shmem_allocations view can be read only by superusers.