System Health & Capacity Planning#

The EXA_MONITOR_* and EXA_DB_SIZE_* tables provide a continuous record of hardware resource usage and storage consumption. Use them to detect performance bottlenecks, identify memory pressure, and plan infrastructure growth.

EXA_MONITOR_LAST_DAY#

Contains one row per measurement interval (approximately every minute) for the past 24 hours. Key columns:

Column	Description
`MEASURE_TIME`	Timestamp of the measurement
`CPU`	Average CPU usage across all cluster nodes (%)
`LOAD`	System load average
`TEMP_DB_RAM`	Temporary DB RAM in use (MiB)
`PERSISTENT_DB_RAM`	Persistent DB RAM in use (MiB)
`SWAP`	Swap space in use — values above 0 indicate memory pressure (MiB)
`HDD_READ` / `HDD_WRITE`	Disk read/write throughput (MiB/s)
`NET`	Network traffic (MiB/s)

EXA_MONITOR_DAILY#

Aggregates monitor data per calendar day. Each metric has both an _AVG and _MAX variant (e.g., CPU_AVG, CPU_MAX). Use this table to identify days with unusual load or to compare weekly performance trends.

EXA_DB_SIZE_LAST_DAY#

Tracks storage volume metrics at the cluster level, measured approximately every hour. Key columns:

Column	Description
`SIZE_RAW_COMPRESSED`	Compressed data volume (MiB)
`SIZE_UNCOMPRESSED`	Uncompressed (raw) data volume (MiB)
`RECOMMENDED_DB_RAM_SIZE`	RAM size Exasol recommends for optimal query performance (MiB)
`SIZE_PERSISTENT_VOLUME`	Total persistent storage allocated (MiB)
`SIZE_PERSISTENT_VOLUME_PERCENTAGE`	Percentage of persistent volume currently used

EXA_DB_SIZE_DAILY#

Daily aggregation of database size metrics. Use this table to track storage growth over weeks and months and to feed capacity planning reports.

Recipes#

Snapshot Current System Resource Usage#

SELECT MEASURE_TIME, CPU, LOAD, TEMP_DB_RAM, PERSISTENT_DB_RAM, SWAP
FROM EXA_MONITOR_LAST_DAY
ORDER BY MEASURE_TIME DESC
LIMIT 10;

Detect Memory Pressure#

Swap usage above zero suggests the database is under memory pressure. Sustained swap values warrant a RAM review or workload optimisation.

SELECT MEASURE_TIME, SWAP, CPU, TEMP_DB_RAM
FROM EXA_MONITOR_LAST_DAY
WHERE SWAP > 0
ORDER BY MEASURE_TIME DESC;

Check Storage Utilization and Recommended RAM#

SELECT MEASURE_TIME,
       SIZE_RAW_COMPRESSED,
       SIZE_PERSISTENT_VOLUME,
       SIZE_PERSISTENT_VOLUME_PERCENTAGE,
       RECOMMENDED_DB_RAM_SIZE
FROM EXA_DB_SIZE_LAST_DAY
ORDER BY MEASURE_TIME DESC
LIMIT 1;

Track Storage Growth Over the Last Two Weeks#

SELECT MEASURE_TIME,
       SIZE_RAW_COMPRESSED
FROM EXA_DB_SIZE_DAILY
ORDER BY MEASURE_TIME DESC
LIMIT 14;

Further reading: EXA_MONITOR_LAST_DAY · EXA_MONITOR_DAILY · EXA_DB_SIZE_LAST_DAY