Back to Clickhouse

system.resources

docs/en/operations/system-tables/resources.md

26.4.1.1-new620 B
Original Source

system.resources

Contains information about resources residing on the local server. The table contains a row for every resource.

Example:

sql
SELECT *
FROM system.resources
FORMAT Vertical
text
Row 1:
──────
name:         io_read
read_disks:   ['s3']
write_disks:  []
create_query: CREATE RESOURCE io_read (READ DISK s3)

Row 2:
──────
name:         io_write
read_disks:   []
write_disks:  ['s3']
create_query: CREATE RESOURCE io_write (WRITE DISK s3)

Columns:

<!--AUTOGENERATED_START--> <!--AUTOGENERATED_END-->