system.resources

System table containing information about resources residing on the local server with one row for every resource.

Description

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

Columns

• name (String) — The name of the resource.
• read_disks (Array(String)) — The list of disk names that uses this resource for read operations.
• write_disks (Array(String)) — The list of disk names that uses this resource for write operations.
• unit (String) — Resource unit used for cost measurements.
• create_query (String) — CREATE query of the resource.

Example:

SELECT *
FROM system.resources
FORMAT Vertical

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)