目录

pg_shmem_allocations

显示共享内存分配的系统视图

pg_shmem_allocations 是一个 系统目录 视图，显示从服务器主共享内存段中进行的分配。

pg_shmem_allocations 在 PostgreSQL 13 中添加。

按PostgreSQL版本定义

pg_shmem_allocations (PostgreSQL 18)

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

文档: pg_shmem_allocations

pg_shmem_allocations (PostgreSQL 17)

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

文档: pg_shmem_allocations

pg_shmem_allocations (PostgreSQL 16)

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

文档: pg_shmem_allocations

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 |           |          |

文档: 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 |           |          |

文档: 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 |           |          |

文档: pg_shmem_allocations

修改历史

示例

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)

分类

PostgreSQL内部机制，系统目录

反馈

提交任何关于 "pg_shmem_allocations" 的评论、建议或更正 在此。