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