↑↓ 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 PG 18 manual ↗

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

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

Columns 4

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
Column9.09.19.29.39.49.59.61011121314151617181920
name··········●●●●●●●●
off··········●●●●●●●●
size··········●●●●●●●●
allocated_size··········●●●●●●●●
Version history 6
  1. PG 17 → 18changed
  2. PG 16 → 17changed
  3. PG 15 → 16changed
  4. PG 14 → 15changed
  5. PG 13 → 14changed
  6. PG 12 → 13added

Definition snapshot: english-manuals:3cb093d4bb5e0e98d8c9a361c2e… · English manual source