{"Entry":{"collection":"catalog","key":"pg_shmem_allocations","name":"pg_shmem_allocations","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","order":false,"removed":[],"status":"added","to":"13","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Size of the allocation 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.","name":"allocated_size","to":"Size 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."},{"from":"Size of the allocation","name":"size","to":"Size of the allocation in bytes"}],"from":"15","listing":[],"order":false,"removed":[],"status":"reworded","to":"16","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"17","listing":[],"order":false,"removed":[],"status":"reworded","to":"18","types":[],"unlisted":[]}],"column_count":4,"content_hash":"39d5a33e0472ed4e996bf3e72e01069ff362543c9c835b5ad634410e8a4502f6","first_version":"13","imported_at":"2026-09-30T00:40:55.831048+08:00","kind":"view","last_version":"20","name":"pg_shmem_allocations","position":78,"present_in":["13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:325315f88c5d71a3446d35e5da1013a61f7522dcf37637cfae5bb4850e85de21","summary":"The pg_shmem_allocations view shows allocations made from the server's main shared memory segment.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_shmem_allocations","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_shmem_allocations","SourceRevision":"english-manuals:325315f88c5d71a3446d35e5da1013a61f7522dcf37637cfae5bb4850e85de21","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The name of the shared memory allocation. NULL for unused memory and \u003canonymous\u003e for anonymous allocations.","description_zh":"","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":2,"description":"The offset at which the allocation starts. NULL for anonymous allocations, since details related to them are not known.","description_zh":"","documented":true,"documented_name":"off","hidden":false,"name":"off","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":3,"description":"Size of the allocation in bytes","description_zh":"","documented":true,"documented_name":"size","hidden":false,"name":"size","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Size 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.","description_zh":"","documented":true,"documented_name":"allocated_size","hidden":false,"name":"allocated_size","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20}],"description":"The pg_shmem_allocations view shows allocations made from the server's main shared memory segment. This includes both memory allocated by PostgreSQL itself and memory allocated by extensions using the mechanisms detailed in Section 36.10.11.\n\nNote that this view does not include memory allocated using the dynamic shared memory infrastructure.","description_zh":"","doc":{"anchor":"id-1.10.5.31.5","file":"view-pg-shmem-allocations.html","lang":"en","sha256":"8228f8da6fb65b47942b5b78469fb6db2352ebe5f94482908a8c87219e134b4e","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","off","size","allocated_size"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.31.5","file":"view-pg-shmem-allocations.html","lang":"en","sha256":"8228f8da6fb65b47942b5b78469fb6db2352ebe5f94482908a8c87219e134b4e","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","off","size","allocated_size"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_shmem_allocations","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_shmem_allocations","Summary":"pg_shmem_allocations视图显示从服务器的主共享内存段分配的内存。这包括PostgreSQL本身分配的内存，以及扩展使用第 36.10.11 节中详细描述的机制分配的内存。\n\n请注意，此视图不包括使用动态共享内存基础设施分配的内存。","BodyHTML":"\u003cp\u003epg_shmem_allocations视图显示从服务器的主共享内存段分配的内存。这包括PostgreSQL本身分配的内存，以及扩展使用第 36.10.11 节中详细描述的机制分配的内存。\n\n请注意，此视图不包括使用动态共享内存基础设施分配的内存。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"cf9a49a3307ac087196ea5c912ae288db01f6694ac9ed2ba8ebb0ecada9dbfe7","Payload":{"columns":[{"description_zh":"共享内存分配的名称。未使用的内存为 NULL，匿名分配为 \u003canonymous\u003e。","name":"name","type":"text","zh_from":"doc"},{"description_zh":"分配开始的偏移量。对于匿名分配，该值为 NULL，因为无法获知与其相关的详细信息。","name":"off","type":"bigint","zh_from":"doc"},{"description_zh":"以字节表示的分配大小","name":"size","type":"bigint","zh_from":"doc"},{"description_zh":"以字节计的分配大小，包括填充。对于匿名分配，没有关于填充的信息，因此 size 和 allocated_size 两列始终相等。填充对于空闲内存没有意义，因此这种情况下这两列也相等。","name":"allocated_size","type":"bigint","zh_from":"doc"}],"description_zh":"pg_shmem_allocations视图显示从服务器的主共享内存段分配的内存。这包括PostgreSQL本身分配的内存，以及扩展使用第 36.10.11 节中详细描述的机制分配的内存。\n\n请注意，此视图不包括使用动态共享内存基础设施分配的内存。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}