ClickHouse Table - Column Size

ClickHouse Table - Column Size

ClickHouse Table - Column Size 구하는 쿼리입니다. 

 

ClickHouse Table Size

아래의 쿼리를 실행하면 테이블별 사이즈를 확인할 수 있고, 압축된용량과 압축해제시용량을 확인 할 수 있습니다.

SELECT
    database,
    table,
    formatReadableSize(sum(data_compressed_bytes) AS size) AS compressed,
    formatReadableSize(sum(data_uncompressed_bytes) AS usize) AS uncompressed,
    round(usize / size, 2) AS compr_rate,
    sum(rows) AS rows,
    count() AS part_count
FROM system.parts
WHERE (active = 1) AND (database LIKE '%') AND (table LIKE '%')
GROUP BY
    database,
    table
ORDER BY size DESC;

ClickHouse Column Size

아래의 쿼리를 실행하면 테이블별 column 사이즈를 확인할 수 있습니다.

SELECT
    database,
    table,
    column,
    formatReadableSize(sum(column_data_compressed_bytes) AS size) AS compressed,
    formatReadableSize(sum(column_data_uncompressed_bytes) AS usize) AS uncompressed,
    round(usize / size, 2) AS compr_ratio,
    sum(rows) rows_cnt,
    round(usize / rows_cnt, 2) avg_row_size
FROM system.parts_columns
WHERE (active = 1) AND (database LIKE '%') AND (table LIKE '%')
GROUP BY
    database,
    table,
    column
ORDER BY size DESC;