v.22.11Improvement

Add bytes_on_disk and path columns to system.detached_parts

Add columns bytes_on_disk and path to system.detached_parts. Closes #42264. #42303 (chen).
Added bytes_on_disk and path columns to the system.detached_parts table in ClickHouse.

Why it matters

This feature provides detailed information about detached parts by showing their size on disk and the filesystem path, helping users to better understand storage usage and locate detached parts for maintenance or debugging purposes.

How to use it

Query the system.detached_parts table to retrieve the new bytes_on_disk and path columns, for example:

SELECT name, bytes_on_disk, path FROM system.detached_parts;