select pg_size_pretty(sum(pg_total_relation_size(inhrelid::regclass)))
from pg_inherits where inhparent='<schema>.<table>'::regclass;
pg_size_pretty
----------------
4410 GB
How to find total size of partition table and its indexes on Postgresql?
Published by
on
Alex Lima 
Leave a comment