pg_shmem_allocations

The pg_shmem_allocations view shows allocations made from the server's main shared memory segment. This includes both memory allocated by PostgreSQL itself and memory allocated by extensions using the mechanisms detailed in Section 36.10.11. Note that this view does not include memory allocated using the dynamic shared memory infrastructure.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

13 14 15 16 17 18 19 20

kind: view
lang: en
measured attributes: true
metadata release: 18.6
runtime columns: name, off, size, allocated_size
runtime verified: false
source: english-manual

Definition PG 18

Catalog columns

Column	Type	Nullability	Description
name	text	Nullable	The name of the shared memory allocation. NULL for unused memory and <anonymous> for anonymous allocations.
off	int8	Nullable	The offset at which the allocation starts. NULL for anonymous allocations, since details related to them are not known.
size	int8	Nullable	Size of the allocation in bytes
allocated_size	int8	Nullable	Size of the allocation in bytes including padding. For anonymous allocations, no information about padding is available, so the size and allocated_size columns will always be equal. Padding is not meaningful for free memory, so the columns will be equal in that case also.

Compare versions

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:51d058eb72229a03a99055c6043d0e1073ed1da0c794d59d91ba5871fc09087a

Text language: en · catalog-bilingual-repair:51d058eb72229a03a99055c6043d0e1073ed1da0c794d59d91ba5871fc09087a