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

PV_TOTAL_MEMORY_DETAIL

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

PV_TOTAL_MEMORY_DETAIL displays statistics about memory usage of the current database node in the unit of MB.

Table 1 PV_TOTAL_MEMORY_DETAIL columns

Name

Type

Description

nodename

text

Node name

memorytype

text

Memory type. Its value can be:

  • 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 allocated memory-typed memory

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