↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System views

pg_shmem_allocations

Read the PG 18 manual

The pg_shmem_allocations view shows allocations made from the server's main shared memory segment.

Reading PG 18current·documented in 8 of 24 versions, 13 to 20

Kind
System views
Columns in this snapshot
4
Definition source
English manual
Metadata snapshot
18.6

Columns 4

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
nametextThe name of the shared memory allocation. NULL for unused memory and <anonymous> for anonymous allocations.
offint8The offset at which the allocation starts. NULL for anonymous allocations, since details related to them are not known.
sizeint8Size of the allocation in bytes
allocated_sizeint8Size 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.
Column history across versions
Version history 6
  1. 17 → 18 reworded
  2. 16 → 17 reworded
  3. 15 → 16 reworded
  4. 14 → 15 reworded
  5. 13 → 14 reworded
  6. 12 → 13 added

Definition snapshot: english-manuals:325315f88c5d71a3446d35e5da1… · English manual source