memory_info
The memory_info view of the gpperfmon database shows per-host memory information from the system_history and segment_history tables.
This allows administrators to compare the total memory available on a segment host, total memory used on a segment host, and dynamic memory used by query processes.
| Column | Type | Description |
|---|---|---|
ctime |
timestamp(0) without time zone |
Time this row was created in the |
hostname |
varchar(64) |
Segment or master hostname associated with these system memory metrics |
mem_total_mb |
numeric |
Total system memory in megabytes for this segment host |
mem_used_mb |
numeric |
Total system memory used in megabytes for this segment host |
mem_actual_used_mb |
numeric |
Actual system memory used in megabytes for this segment host |
mem_actual_free_mb |
numeric |
Actual system memory free in megabytes for this segment host |
swap_total_mb |
numeric |
Total swap space in megabytes for this segment host |
swap_used_mb |
numeric |
Total swap space used in megabytes for this segment host |
dynamic_memory_used_mb |
numeric |
The amount of dynamic memory in megabytes allocated to query processes running on this segment |
dynamic_memory_available_mb |
numeric |
The amount of additional dynamic memory (in megabytes) available to the query processes running on this segment host. Note that this value is a sum of the available memory for all segments on a host. Even though this value reports available memory, it is possible that one or more segments on the host have exceeded their memory limit |