PG_TOTAL_MEMORY_DETAIL

nodename

Text

Node name

memorytype

Text

It can be set to any of the following values:

• max_process_memory: memory used by a DWS cluster instance
• process_used_memory: memory used 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 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
• max_topsql_memory: maximum memory that can be used by top SQL to record historical job monitoring information
• topsql_used_memory: memory used by top SQL to record historical job monitoring information
• topsql_peak_memory: memory peak of top SQL to record historical job monitoring information
• 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)