EXA_DB_SIZE_HOURLY
This system table contains information about hourly 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. |