with t as (select * from pg_catalog.pg_tables
where schemaname = 'public'),
sizes as (
select t.tablename, pg_total_relation_size(t.tablename::regclass) _size from t
order by 2 desc),
total as (select sum(_size) _size from sizes)
select sizes.tablename, sizes._size, to_char(sizes._size / total._size * 100.0,'999D99%') from sizes, total;
Created
November 22, 2023 15:34
-
-
Save 62mkv/6bd0967d6050cbd000d70f37b3f698dd to your computer and use it in GitHub Desktop.
Postgre recipes
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment