查看表、存储信息、压缩比等。 

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_compressedbytes,
	compress_rate,
	rows
from
(
	select
		database,
		table,
		sum(bytes) as size,
		sum(rows) as rows,
		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
	from system.parts
	where active 
	and partition='2022-03-02'
	and database='ads_ck'
	and table='ADS_TMP_ALL'
	group by 
	database,
	table
)