Help Center > > Developer Guide> System Catalogs and System Views> System Views> PGXC_TOTAL_MEMORY_DETAIL

PGXC_TOTAL_MEMORY_DETAIL

Updated at: Jul 15, 2020 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel