This system table contains the monthly aggregated monitoring information (of values from EXA_MONITOR_LAST_DAY) for a cluster, sorted by the interval start and cluster name. All users have access to the table.
| Column Name | Description |
|---|---|
| CLUSTER_NAME | Name of the cluster |
| INTERVAL_START | Timestamp at the start of the aggregation interval |
| LOAD_AVG | Average system load (equals the 1-minute load value of program up time) |
| LOAD_MAX | Maximum system load (equals the 1-minute load value of program up time) |
| CPU_AVG | Average CPU utilization in percentage (of the database instance) |
| CPU_MAX | Maximum CPU utilization in percentage (of the database instance) |
| TEMP_DB_RAM_AVG | Average usage of temporary DB memory in MiB (of the database instance) |
| TEMP_DB_RAM_MAX | Maximum usage of temporary DB memory in MiB (of the database instance) |
| PERSISTENT_DB_RAM_AVG | Average usage of modified, persistent DB memory in MiB (of the database instance) |
| PERSISTENT_DB_RAM_MAX | Maximum usage of modified, persistent DB memory in MiB (of the database instance) |
| HDD_READ_AVG | Average hard disk read ratio in MiB per second |
| HDD_READ_MAX | Maximum hard disk read ratio in MiB per second |
| HDD_WRITE_AVG | Average hard disk write ratio in MiB per second |
| HDD_WRITE_MAX | Maximum hard disk write ratio in MiB per second |
| LOCAL_READ_SIZE_AVG | Average data size read from local (non-cache) storage in MiB |
| LOCAL_READ_SIZE_MAX | Maximum data size read from local (non-cache) storage in MiB |
| LOCAL_READ_DURATION_AVG | Average duration spent reading data from local (non-cache) storage in seconds |
| LOCAL_READ_DURATION_MAX | Maximum duration spent reading data from local (non-cache) storage in seconds |
| LOCAL_WRITE_SIZE_AVG | Average data size written to local (non-cache) storage in MiB |
| LOCAL_WRITE_SIZE_MAX | Maximum data size written to local (non-cache) storage in MiB |
| LOCAL_WRITE_DURATION_AVG | Average duration spent writing data to local (non-cache) storage in seconds |
| LOCAL_WRITE_DURATION_MAX | Maximum duration spent writing data to local (non-cache) storage in seconds |
| CACHE_READ_SIZE_AVG | Average data size read from cache in MiB |
| CACHE_READ_SIZE_MAX | Maximal data size read from cache in MiB |
| CACHE_READ_DURATION_AVG | Average duration spent reading data from cache in seconds |
| CACHE_READ_DURATION_MAX | Maximum duration spent reading data from cache in seconds |
| CACHE_WRITE_SIZE_AVG | Average data size written to cache in MiB |
| CACHE_WRITE_SIZE_MAX | Maximum data size written to cache in MiB |
| CACHE_WRITE_DURATION_AVG | Average duration spent writing data to cache in seconds |
| CACHE_WRITE_DURATION_MAX | Maximum duration spent writing data to cache in seconds |
| REMOTE_READ_SIZE_AVG | Average data size read from remote storage in MiB |
| REMOTE_READ_SIZE_MAX | Maximum data size read from remote storage in MiB |
| REMOTE_READ_DURATION_AVG | Average duration spent reading data from remote storage in seconds |
| REMOTE_READ_DURATION_MAX | Maximum duration spent reading data from remote storage in seconds |
| REMOTE_WRITE_SIZE_AVG | Average data size written to remote storage in MiB |
| REMOTE_WRITE_SIZE_MAX | Maximum data size written to remote storage in MiB |
| REMOTE_WRITE_DURATION_AVG | Average duration spent writing data to remote storage in seconds |
| REMOTE_WRITE_DURATION_MAX | Maximum duration spent writing data to remote storage in seconds |
| NET_AVG | Average network traffic ratio in MiB per second |
| NET_MAX | Maximum network traffic ratio in MiB per second |
| SWAP_AVG |
Average
swap ratio in MiB per
second.
A value higher than 0 can indicate a system configuration issue. |
| SWAP_MAX |
Maximum swap ratio in MiB per
second.
A value higher than 0 can indicate a system configuration issue. |