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