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 GaussDB(DWS) cluster instance
- process_used_memory: memory occupied 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 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 this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.