52.4. pg_backend_memory_contexts (original) (raw)
Development Versions:devel
The view pg_backend_memory_contexts displays all the memory contexts of the server process attached to the current session.
pg_backend_memory_contexts contains one row for each memory context.
Table 52.4. pg_backend_memory_contexts Columns
| Column Type Description |
|---|
| name text Name of the memory context |
| ident text Identification information of the memory context. This field is truncated at 1024 bytes |
| parent text Name of the parent of this memory context |
| level int4 Distance from TopMemoryContext in context tree |
| total_bytes int8 Total bytes allocated for this memory context |
| total_nblocks int8 Total number of blocks allocated for this memory context |
| free_bytes int8 Free space in bytes |
| free_chunks int8 Total number of free chunks |
| used_bytes int8 Used space in bytes |
By default, the pg_backend_memory_contexts view can be read only by superusers or roles with the privileges of the pg_read_all_stats role.