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 |
UNUSED_DATA | Unused data on the node in GiB. Be aware that volume fragmentation might prevent complete use of all unused data. |
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. |