sanchezzzhak/clickhouse-get-tables-size.sql

Created January 18, 2018 13:43

Star 220 You must be signed in to star a gist
Fork 34 You must be signed in to fork a gist

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

Download ZIP

clickhouse get tables size

Raw

clickhouse-get-tables-size.sql

	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

sanalchandran commented Mar 3, 2023

Thanks a lot. Very helpful scripts.

alexeyantropov commented Aug 8, 2023

Thx you guys and gals! Real useful sqls! You've just inspired me to code a little exporter to view the presented data in prometheus or grafana.

alexeyantropov commented Aug 10, 2023

Thx you guys and gals! Real useful sqls! You've just inspired me to code a little exporter to view the presented data in prometheus or grafana.

Mmm... Smth like this https://github.com/alexeyantropov/clickhouse_table_exporter/blob/main/src/exporter.py

aitudorm commented Aug 29, 2023

@alexeyantropov do you mind to add some custom queries? Have you finished to code a little exporter?

alexeyantropov commented Aug 29, 2023

@alexeyantropov do you mind to add some custom queries? Have you finished to code a little exporter?

I've finished and use it in my production environment. But sure I can add some extra queries and metrics. What have you to suggest?

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