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

PV_TOTAL_MEMORY_DETAIL

Updated at: Sep 17, 2021 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 used by a GaussDB(DWS) cluster instance
  • process_used_memory: memory used by a GaussDB(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 for column store
  • cstore_used_memory: memory used for column store
  • max_sctpcomm_memory: maximum memory allowed for the communication library
  • sctpcomm_used_memory: memory used for the communication library
  • sctpcomm_peak_memory: memory peak of the communication library
  • other_used_memory: other used memory
  • gpu_max_dynamic_memory: maximum GPU memory
  • gpu_dynamic_used_memory: sum of the available GPU memory and temporary GPU memory
  • gpu_dynamic_peak_memory: maximum memory used for GPU
  • pooler_conn_memory: memory used for pooler connections
  • pooler_freeconn_memory: memory used for idle pooler connections
  • storage_compress_memory: memory used for column-store compression and decompression
  • udf_reserved_memory: memory reserved for the UDF Worker process
  • mmap_used_memory: memory used for mmap

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