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

PG_TOTAL_MEMORY_DETAIL

Updated at: Sep 17, 2021 GMT+08:00

PG_TOTAL_MEMORY_DETAIL displays the memory usage of a certain node in the database.

Table 1 PG_TOTAL_MEMORY_DETAIL columns

Name

Type

Description

nodename

text

Node name

memorytype

text

It can be set to any of the following values:

  • 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 the used memory (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