pg_shmem_allocations

A system catalogue view showing allocations made from the server's main shared memory segment

pg_shmem_allocations is a system catalogue view showing allocations made from the server's main shared memory segment.

pg_shmem_allocations was added in PostgreSQL 13.

Definition by PostgreSQL version

pg_shmem_allocations (PostgreSQL 13)

          View "pg_catalog.pg_shmem_allocations"
     Column     |  Type  | Collation | Nullable | Default
----------------+--------+-----------+----------+---------
 name           | text   |           |          |
 off            | bigint |           |          |
 size           | bigint |           |          |
 allocated_size | bigint |           |          |
    

Documentation: pg_shmem_allocations

Change history

Examples

postgres=# SELECT * FROM pg_shmem_allocations WHERE name LIKE 'Backend%' ORDER BY name;
              name               |    off    |  size  | allocated_size 
---------------------------------+-----------+--------+----------------
 Backend Activity Buffer         | 288185472 | 131072 |         131072
 Backend Application Name Buffer | 288169088 |   8192 |           8192
 Backend Client Host Name Buffer | 288177280 |   8192 |           8192
 Backend SSL Status Buffer       | 288316544 |  41984 |          41984
 Backend Status Array            | 288114816 |  54272 |          54272
(5 rows)

Categories

PostgreSQL internals, System catalogue