• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PGXC_TOTAL_MEMORY_DETAIL

PGXC_TOTAL_MEMORY_DETAIL

PGXC_TOTAL_MEMORY_DETAIL displays the memory usage in the cluster.

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 DWS cluster instance
  • process_used_memory: memory occupied by a DWS process
  • max_dynamic_memory: maximum dynamic memory
  • dynamic_used_memory: used dynamic memory
  • dynamic_peak_memory: dynamic peak value of the memory
  • 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_cstore_memory: maximum memory allowed by column storage
  • cstore_used_memory: memory used in column storage
  • max_sctpcomm_memory: maximum memory size allowed for the communication library
  • sctpcomm_used_memory: memory used by communication library
  • sctpcomm_peak_memory: memory peak of the communication library
  • other_used_memory: other used memory

memorymbytes

integer

Size of the used memory in the unit of MB