pg_shmem_allocations
A system view showing shared memory allocations
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 15)
View "pg_catalog.pg_shmem_allocations"
Column | Type | Collation | Nullable | Default
----------------+--------+-----------+----------+---------
name | text | | |
off | bigint | | |
size | bigint | | |
allocated_size | bigint | | |
Documentation: pg_shmem_allocations
pg_shmem_allocations (PostgreSQL 14)
View "pg_catalog.pg_shmem_allocations"
Column | Type | Collation | Nullable | Default
----------------+--------+-----------+----------+---------
name | text | | |
off | bigint | | |
size | bigint | | |
allocated_size | bigint | | |
Documentation: pg_shmem_allocations
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
- PostgreSQL 15
- can be accessed by members of
pg_read_all_stats(commit 77ea4f94)
- can be accessed by members of
- PostgreSQL 13
- added (commit ed10f32e)
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)
References
- PostgreSQL documentation: pg_shmem_allocations