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. |
