select
pg_size_pretty( sum( pg_relation_size( schemaname || '.' || partitiontablename ) )::bigint )
from
pg_partitions
where
schemaname='hr'
and tablename='employees';