ch_parts_query.sql

SELECT 
    parts.*,
    columns.compressed_size,
    columns.uncompressed_size
FROM 
(
    SELECT 
        table,
        formatReadableSize(sum(data_uncompressed_bytes)) AS uncompressed_size,
        formatReadableSize(sum(data_compressed_bytes)) AS compressed_size
    FROM system.columns
    WHERE database = currentDatabase()
    GROUP BY table
) AS columns
RIGHT JOIN 
(
    SELECT 
        table,
        any(engine) AS engine
    FROM system.parts
    WHERE active AND (database = currentDatabase())
    GROUP BY 
        database,
        table
) AS parts ON columns.table = parts.table