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';