ClickHouse tables size

size.sql

//https://kb.altinity.com/altinity-kb-useful-queries/altinity-kb-database-size-table-column-size/

WITH
    (select free_space from system.disks) as free_space,
    (select total_space from system.disks) as total_space
SELECT name as table,database,
       max(sizebytes) as sizebytes,
       max(size) as size,
       concat(toString(round(sizebytes * 100 / (total_space - free_space), 2)), '%') as size_percent,
       min(min_date) as min_date,
       max(max_date) as max_date,
       formatReadableSize(free_space) as free_size,
       concat(toString(round(free_space * 100 / total_space, 2)), '%') as free_percent,
       formatReadableSize(total_space) as total_size
FROM system.tables
         ANY LEFT JOIN
     (
         SELECT table,database,
                formatReadableSize(sum(bytes)) as size,
                sum(bytes) as sizebytes,
                min(min_date) as min_date,
                max(max_date) as max_date
         FROM system.parts
         WHERE active AND database != 'system'
         GROUP BY table,database
         )a USING ( table,database )
WHERE 1 AND database != 'system'
GROUP BY table,database
ORDER BY sizebytes DESC;