system.disks - Clickhouse

import SystemTableCloud from '@site/docs/_snippets/_system_table_cloud.md';

Contains information about disks defined in the server configuration.

Columns:

Example

sql

SELECT * FROM system.disks;

response

┌─name────┬─path─────────────────┬───free_space─┬──total_space─┬─keep_free_space─┐
│ default │ /var/lib/clickhouse/ │ 276392587264 │ 490652508160 │               0 │
└─────────┴──────────────────────┴──────────────┴──────────────┴─────────────────┘

1 rows in set. Elapsed: 0.001 sec.