進(jìn)入終端:sudo docker exec -it msun-clickhouse clickhouse-client --port 10000 --user 用戶--password 密碼 -m
select database, table, formatReadableSize(size) as size, formatReadableSize(bytes_on_disk) as bytes_on_disk, formatReadableSize(data_uncompressed_bytes) as data_uncompressed_bytes, formatReadableSize(data_compressed_bytes) as data_compressed_bytes, compress_rate, rows, days, formatReadableSize(avgDaySize) as avgDaySize from ( select database, table, sum(bytes) as size, sum(rows) as rows, min(min_date) as min_date, max(max_date) as max_date, sum(bytes_on_disk) as bytes_on_disk, sum(data_uncompressed_bytes) as data_uncompressed_bytes, sum(data_compressed_bytes) as data_compressed_bytes, (data_compressed_bytes / data_uncompressed_bytes) * 100 as compress_rate, max_date - min_date as days, size / (max_date - min_date) as avgDaySize from system.parts where active and database = '數(shù)據(jù)庫' and table = '數(shù)據(jù)表' group by database, table );
浙公網(wǎng)安備 33010602011771號