Handy Clickhouse queries

clickhouse_disk_space_per_table.sql

SELECT
    table,
    formatReadableSize(sum(bytes)) AS size,
    min(min_date) AS min_date,
    max(max_date) AS max_date
FROM system.parts
WHERE active
GROUP BY table
ORDER BY sum(bytes) DESC

clickhouse_disk_spce_per_table_except_temp.sql

SELECT
    table,
    formatReadableSize(sum(bytes)) AS size,
    min(min_date) AS min_date,
    max(max_date) AS max_date
FROM system.parts
WHERE active AND (table NOT LIKE '.inner%') AND (table NOT LIKE '_tmp%')
GROUP BY table
ORDER BY sum(bytes) DESC

clickhouse_test_tables.sql

SELECT database, table FROM system.tables where table like '%test%'