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

PGXC_TOTAL_MEMORY_DETAIL

PGXC_TOTAL_MEMORY_DETAIL displays memory usage in the cluster. The query can be performed only on the CN. The EXECUTE DIRECT ON (dn) 'SELECT * FROM PGXC_TOTAL_MEMORY_DETAIL'; statement is not supported. Only users with the SYSADMIN and monitor admin permissions can query this view. For details about the columns, see Table 1.

Table 1 PGXC_TOTAL_MEMORY_DETAIL columns

Name

Type

Description

nodename

text

Node name.

memorytype

text
Memory name.
  • 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 memory peak.
  • dynamic_used_shrctx: maximum dynamic shared memory context.
  • dynamic_peak_shrctx: dynamic peak value of the shared memory context.
  • 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.

memorymbytes

integer

Size of the used memory (unit: MB).
Parent topic: Other System Views