> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about disks defined in the server configuration

# system.disks

<Info>
  **Querying in ClickHouse Cloud**

  The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/reference/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.
</Info>

<h2 id="description">
  Description
</h2>

Contains information about disks defined in the [server configuration](/reference/engines/table-engines/mergetree-family/mergetree#table_engine-mergetree-multiple-volumes_configure).

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types)) — Name of a disk in the server configuration.
* `path` ([String](/reference/data-types)) — Path to the mount point in the file system.
* `free_space` ([UInt64](/reference/data-types)) — Free space on disk in bytes.
* `total_space` ([UInt64](/reference/data-types)) — Disk volume in bytes.
* `unreserved_space` ([UInt64](/reference/data-types)) — Free space which is not taken by reservations (free\_space minus the size of reservations taken by merges, inserts, and other disk write operations currently running).
* `keep_free_space` ([UInt64](/reference/data-types)) — Amount of disk space that should stay free on disk in bytes. Defined in the keep\_free\_space\_bytes parameter of disk configuration.
* `type` ([String](/reference/data-types)) — The disk type which tells where this disk stores the data - RAM, local drive or remote storage.
* `object_storage_type` ([String](/reference/data-types)) — Type of object storage if disk type is object\_storage
* `metadata_type` ([String](/reference/data-types)) — Type of metadata storage if disk type is object\_storage
* `is_encrypted` ([UInt8](/reference/data-types)) — Flag which shows whether this disk encrypts the underlying data.
* `is_read_only` ([UInt8](/reference/data-types)) — Flag which indicates that you can only perform read operations with this disk.
* `is_write_once` ([UInt8](/reference/data-types)) — Flag which indicates if disk is write-once. Which means that it does support BACKUP to this disk, but does not support INSERT into MergeTree table on this disk.
* `is_remote` ([UInt8](/reference/data-types)) — Flag which indicated what operations with this disk involve network interaction.
* `is_broken` ([UInt8](/reference/data-types)) — Flag which indicates if disk is broken. Broken disks will have 0 space and cannot be used.
* `cache_path` ([String](/reference/data-types)) — The path to the cache directory on local drive in case when the disk supports caching.

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT * FROM system.disks;
```

```response theme={null}
┌─name────┬─path─────────────────┬───free_space─┬──total_space─┬─keep_free_space─┐
│ default │ /var/lib/clickhouse/ │ 276392587264 │ 490652508160 │               0 │
└─────────┴──────────────────────┴──────────────┴──────────────┴─────────────────┘

1 rows in set. Elapsed: 0.001 sec.
```