Size of partitioned table

posted Apr 28, 2017, 4:07 PM by Sachchida Ojha
select
pg_size_pretty( sum( pg_relation_size( schemaname || '.' || partitiontablename ) )::bigint )
from
pg_partitions
where
schemaname='hr'
and tablename='employees';
Comments