pg_backend_memory_contexts
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 56.4. pg_backend_memory_contexts Columns
Column Type Description |
|---|
Name of the memory context |
Identification information of the memory context. This field is truncated at 1024 bytes |
Name of the parent of this memory context |
Distance from TopMemoryContext in context tree |
Total bytes allocated for this memory context |
Total number of blocks allocated for this memory context |
Free space in bytes |
Total number of free chunks |
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.