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