The system table shows details of the database usage of the cloud storage volumes. All users have access to the table.
Column Name | Description |
---|---|
CLUSTER_ID | The identifier of the cluster. |
TABLESPACE | The tablespace of the volume |
IPROC | Number of the node |
COMMIT_DATA | Committed data on the node in GiB |
SWAP_DATA | Swapped data on the node in GiB |
VOLUME_ID | The identifier of the volume. |
DELETE_DATA | Deleted data on the node in GiB. This includes all data which cannot be deleted immediately, e.g. because of an active backup or shrink operation. |
MULTICOPY_DATA | Multicopy data on the node in GiB. Multicopy data occurs in case of transactions where one transaction reads old data and the other one writes new data of the same table in parallel. |
SNAPSHOT_BACKUP_DATA | Snapshot backup data on the node in GiB. This includes all data which is not used by the database any more but cannot be deleted because it is referenced by at least one snapshot backup. |