Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ GS_TOTAL_MEMORY_DETAIL
Updated on 2025-08-19 GMT+08:00
View PDF

GS_TOTAL_MEMORY_DETAIL

GS_TOTAL_MEMORY_DETAIL displays the memory usage of the current database node, in MB. If the GUC parameter enable_memory_limit is set to off, this view is unavailable. In the multi-tenancy scenario, an empty value is returned in a PDB.

Table 1 GS_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 the GaussDB instance
  • process_used_memory: memory occupied by the 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.
Parent topic: Other System Views