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