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