notz/clickhouse-table-sizes.sql

Created September 10, 2025 20:53

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/notz/60e573c7de8700b22ad733aa286474c7.js"></script>
Save notz/60e573c7de8700b22ad733aa286474c7 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

clickhouse-table-sizes.sql

SELECT database, table, formatReadableSize(sum(bytes)) AS size FROM system.parts GROUP BY database, table ORDER BY sum(bytes) DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment