EXA_DB_SIZE_MONTHLY

This system table contains information about monthly aggregated database sizes at cluster level, sorted by the interval start. All users have access to the table.

Column Name Description
CLUSTER_NAME Name of the cluster
INTERVAL_START Start point of the aggregation interval
RAW_OBJECT_SIZE_AVG Average uncompressed data volume in GiB
RAW_OBJECT_SIZE_MAX Maximum uncompressed data volume in GiB
MEM_OBJECT_SIZE_AVG Average compressed data volume in GiB
MEM_OBJECT_SIZE_MAX Maximum compressed data volume in GiB
AUXILIARY_SIZE_AVG Average size in GiB of auxiliary structures like indexes
AUXILIARY_SIZE_MAX Maximum size in GiB of auxiliary structures like indexes
STATISTICS_SIZE_AVG Average size in GiB of statistical system tables
STATISTICS_SIZE_MAX Maximum size in GiB of statistical system tables
RECOMMENDED_DB_RAM_SIZE_AVG Average recommended DB RAM size in GiB to achieve the optimal system performance
RECOMMENDED_DB_RAM_SIZE_MAX Maximum recommended DB RAM size in GiB to achieve the optimal system performance
STORAGE_SIZE_AVG Average size of the persistent volume in GiB
STORAGE_SIZE_MAX Maximum size of the persistent volume in GiB
USE_AVG Average ratio of effectively used space of the persistent volume size in percentage
USE_MAX Maximum ratio of effectively used space of the persistent volume size in percentage
TEMP_VOLUME_SIZE_AVG Average size in GiB of the temporary volume
TEMP_VOLUME_SIZE_MAX Maximum size in GiB of the temporary volume
OBJECT_COUNT_AVG Average number of schema objects in the database.
OBJECT_COUNT_MAX Maximum number of schema objects in the database.