The system table shows details of the database usage of the 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 |
VOLUME_ID | The identifier of the volume |
IPROC | Number of the node |
LOCALITY | Describes the locality of the master segment. If the value is FALSE, then a performance degradation of I/O operations is probable. |
REDUNDANCY | Redundancy level of the volume |
HDD_TYPE | Type of HDDs of the volume |
HDD_COUNT | Number of HDDs of the volume |
HDD_FREE | Physical free space on the node in GiB of all disks of the volume |
VOLUME_SIZE | Size of the volume on the node in GiB |
USE | Usage of the volume on the node in percent, i.e. 100% - (UNUSED_ DATA/VOLUME_SIZE) |
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 is data which exists in multiple versions; it is generated when parallel transactions operate on the same data, for instance when one transaction reads some rows from a table and another transaction writes the very same rows in the same table. |
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. |