{"Entry":{"collection":"catalog","key":"pg_backend_memory_contexts","name":"pg_backend_memory_contexts","aliases":[],"metadata":{"changed_in":["18"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"13","order":false,"removed":[],"status":"added","to":"14","types":[]},{"added":["type","path"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Distance from TopMemoryContext in context tree","name":"level","to":"The 1-based level of the context in the memory context hierarchy. The level of a context also shows the position of that context in the path column."}],"from":"17","listing":[],"order":false,"removed":["parent"],"status":"changed","to":"18","types":[],"unlisted":[]}],"column_count":10,"content_hash":"deeb3c2601eda2f54d7062708e9c74c0f31364414991c886b9a8989869719727","first_version":"14","imported_at":"2026-09-30T00:40:55.394754+08:00","kind":"view","last_version":"20","name":"pg_backend_memory_contexts","position":12,"present_in":["14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:a8d86767df53f2006927414d27084c9b879ff8c4a046ef830cde8bebfe3d514b","summary":"The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_backend_memory_contexts","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_backend_memory_contexts","SourceRevision":"english-manuals:a8d86767df53f2006927414d27084c9b879ff8c4a046ef830cde8bebfe3d514b","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of the memory context","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":"Identification information of the memory context. This field is truncated at 1024 bytes","description_zh":"","documented":true,"documented_name":"ident","hidden":false,"name":"ident","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"Type of the memory context","description_zh":"","documented":true,"documented_name":"type","hidden":false,"name":"type","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":4,"description":"The 1-based level of the context in the memory context hierarchy. The level of a context also shows the position of that context in the path column.","description_zh":"","documented":true,"documented_name":"level","hidden":false,"name":"level","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":5,"description":"Array of transient numerical identifiers to describe the memory context hierarchy. The first element is for TopMemoryContext, subsequent elements contain intermediate parents and the final element contains the identifier for the current context.","description_zh":"","documented":true,"documented_name":"path","hidden":false,"name":"path","not_null":false,"references":"","type":"int4[]","type_modifier":-1,"type_oid":1007},{"array_dimensions":0,"attnum":6,"description":"Total bytes allocated for this memory context","description_zh":"","documented":true,"documented_name":"total_bytes","hidden":false,"name":"total_bytes","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Total number of blocks allocated for this memory context","description_zh":"","documented":true,"documented_name":"total_nblocks","hidden":false,"name":"total_nblocks","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Free space in bytes","description_zh":"","documented":true,"documented_name":"free_bytes","hidden":false,"name":"free_bytes","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Total number of free chunks","description_zh":"","documented":true,"documented_name":"free_chunks","hidden":false,"name":"free_chunks","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Used space in bytes","description_zh":"","documented":true,"documented_name":"used_bytes","hidden":false,"name":"used_bytes","not_null":false,"references":"","type":"int8","type_modifier":-1,"type_oid":20}],"description":"The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session.\n\npg_backend_memory_contexts contains one row for each memory context.","description_zh":"","doc":{"anchor":"id-1.10.5.9.5","file":"view-pg-backend-memory-contexts.html","lang":"en","sha256":"fcd6506a0326ec6d4abeaade399fe3336cd4ccc5c13723288de87f299d4628ac","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","ident","type","level","path","total_bytes","total_nblocks","free_bytes","free_chunks","used_bytes"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.9.5","file":"view-pg-backend-memory-contexts.html","lang":"en","sha256":"fcd6506a0326ec6d4abeaade399fe3336cd4ccc5c13723288de87f299d4628ac","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","ident","type","level","path","total_bytes","total_nblocks","free_bytes","free_chunks","used_bytes"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_backend_memory_contexts","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_backend_memory_contexts","Summary":"视图pg_backend_memory_contexts显示附属于当前会话的服务器进程中的全部内存上下文。\n\npg_backend_memory_contexts 为每个内存上下文提供一行。","BodyHTML":"\u003cp\u003e视图pg_backend_memory_contexts显示附属于当前会话的服务器进程中的全部内存上下文。\n\npg_backend_memory_contexts 为每个内存上下文提供一行。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"bdde94abf1207e0d640ca640946fb9f7a08ad92f810e7b64edc4c7f65f9b189f","Payload":{"columns":[{"description_zh":"内存上下文的名称","name":"name","type":"text","zh_from":"doc"},{"description_zh":"内存上下文的标识信息。该字段会在 1024 字节处截断。","name":"ident","type":"text","zh_from":"doc"},{"description_zh":"内存上下文类型","name":"type","type":"text","zh_from":"doc"},{"description_zh":"该上下文在内存上下文层次中的层级，从 1 开始计数。上下文的层级也表示该上下文在 path 列中的位置。","name":"level","type":"integer","zh_from":"doc"},{"description_zh":"由瞬态数字标识符组成的数组，用于描述内存上下文层次。第一个元素对应 TopMemoryContext，后续元素包含中间父上下文，最后一个元素包含当前上下文的标识符。","name":"path","type":"integer[]","zh_from":"doc"},{"description_zh":"为该内存上下文分配的总字节数","name":"total_bytes","type":"bigint","zh_from":"doc"},{"description_zh":"为该内存上下文分配的总块数","name":"total_nblocks","type":"bigint","zh_from":"doc"},{"description_zh":"空闲空间，按字节计","name":"free_bytes","type":"bigint","zh_from":"doc"},{"description_zh":"空闲块总数","name":"free_chunks","type":"bigint","zh_from":"doc"},{"description_zh":"已用空间，按字节计","name":"used_bytes","type":"bigint","zh_from":"doc"}],"description_zh":"视图pg_backend_memory_contexts显示附属于当前会话的服务器进程中的全部内存上下文。\n\npg_backend_memory_contexts 为每个内存上下文提供一行。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}