Size of partitioned table
Post date: Oct 17, 2013 5:18:0 PM
select
pg_size_pretty( sum( pg_relation_size( schemaname || '.' || partitiontablename ) )::bigint )
from
pg_partitions
where
schemaname='hr'
and tablename='employees';
We have migrated to new Google sites!
Post date: Oct 17, 2013 5:18:0 PM
select
pg_size_pretty( sum( pg_relation_size( schemaname || '.' || partitiontablename ) )::bigint )
from
pg_partitions
where
schemaname='hr'
and tablename='employees';