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. The value must be one of the following: - max_process_memory: memory occupied by a GaussDB cluster instance.
- process_used_memory: memory occupied by a GaussDB process.
- max_dynamic_memory: maximum dynamic memory.
- dynamic_used_memory: used dynamic memory.
- dynamic_peak_memory: dynamic memory peak.
- dynamic_used_shrctx: maximum dynamic shared memory context.
- dynamic_peak_shrctx: dynamic peak value of the shared memory context.
- max_backend_memory: maximum memory that can be used when the HA port is used to execute services.
- backend_used_memory: memory that has been used when the HA port is used to execute services.
- max_shared_memory: maximum shared memory.
- shared_used_memory: used shared memory.
- max_sctpcomm_memory: maximum memory allowed for the communications library.
- sctpcomm_used_memory: memory used by the communications library.
- sctpcomm_peak_memory: memory peak of the communications library.
- other_used_memory: other used memory.
|
| memorymbytes | integer | Size of allocated memory-typed memory. |