EXA_MONITOR_LAST_DAY

This system table describes monitoring information (the maximum values in the cluster). All users have access to the table.

Column Name Description
CLUSTER_NAME Name of the cluster
MEASURE_TIME Timestamp of the measurement
LOAD System load (equals the load value of program up time)
CPU CPU utilization in percentage (of the database instance, maximum across all nodes)
TEMP_DB_RAM Usage of temporary DB memory in MiB (of the database instance, maximum across all nodes)
PERSISTENT_DB_RAM Usage of modified, persistent DB memory in MiB (of the database instance, maximum across all nodes)
HDD_READ Hard disk read ratio in MiB per second (per node, maximum across all nodes)
HDD_WRITE Hard disk write ratio in MiB per second (per node, maximum across all nodes)
LOCAL_READ_SIZE Data size read from local (non-cache) storage in MiB, (of the database instance, maximum across all nodes)
LOCAL_READ_DURATION Time in seconds spent reading data from local (non-cache) storage, (of the database instance, maximum across all nodes)
LOCAL_WRITE_SIZE Data size written to local (non-cache) storage in MiB, (of the database instance, maximum across all nodes)
LOCAL_WRITE_DURATION Time in seconds spent writing data to local (non-cache) storage, (of the database instance, maximum across all nodes)
CACHE_READ_SIZE Data size read from cache in MiB, (of the database instance, maximum across all nodes)
CACHE_READ_DURATION Time in seconds spent reading data from cache, (of the database instance, maximum across all nodes)
CACHE_WRITE_SIZE Data size written to cache in MiB, (of the database instance, maximum across all nodes)
CACHE_WRITE_DURATION Time in seconds spent writing data to cache, (of the database instance, maximum across all nodes)
REMOTE_READ_SIZE Data size read from remote storage in MiB, (of the database instance, maximum across all nodes)
REMOTE_READ_DURATION Time in seconds spent reading data from remote storage, (of the database instance, maximum across all nodes)
REMOTE_WRITE_SIZE Data size written to remote storage in MiB, (of the database instance, maximum across all nodes)
REMOTE_WRITE_DURATION Time in seconds spent reading data from remote storage in MiB, (of the database instance, maximum across all nodes)
NET Network traffic ratio in MiB per second (sum of send/receive, per node, maximum across all nodes)
SWAP

Swap ratio in MiB per second (maximum across all nodes).

A value higher than 0 can indicate a system configuration issue.