PV_TOTAL_MEMORY_DETAIL

PV_TOTAL_MEMORY_DETAIL displays statistics about memory usage of the current database node in the unit of MB. For details about the columns, see Table 1.

**Table 1** PV_TOTAL_MEMORY_DETAIL columns
Name	Type	Description
nodename	text	Node name.
memorytype	text	Memory type. The value must be one of the following: max_process_memory: memory occupied by a GaussDB cluster instance. process_used_memory: memory occupied by a GaussDB process. max_dynamic_memory: maximum dynamic memory. dynamic_used_memory: used dynamic memory. dynamic_peak_memory: dynamic peak memory. dynamic_used_shrctx: maximum dynamic shared memory context. dynamic_peak_shrctx: dynamic peak value of the shared memory context. max_backend_memory: maximum memory that can be used when the HA port is used to execute services. backend_used_memory: memory that has been used when the HA port is used to execute services. max_shared_memory: maximum shared memory. shared_used_memory: used shared memory. max_sctpcomm_memory: maximum memory allowed for the communications library. sctpcomm_used_memory: memory used by the communications library. sctpcomm_peak_memory: memory peak of the communications library. other_used_memory: other used memory. llvm_used_memory: memory occupied by the expression IR that is generated by Codegen and is not released.
memorymbytes	integer	Size of allocated memory-typed memory.