v.22.11Improvement
Add bytes_on_disk and path columns to system.detached_parts
Add columnsbytes_on_diskandpathtosystem.detached_parts. Closes #42264. #42303 (chen).
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 thesystem.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;