Mike Ritchie mike-luabase

founder @definite-app (https://www.definite.app/)

sanchezzzhak / clickhouse-get-tables-size.sql

Created January 18, 2018 13:43

clickhouse get tables size

	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