select pg_size_pretty( sum( pg_relation_size( schemaname || '.' || partitiontablename ) )::bigint ) from pg_partitions where schemaname='hr' and tablename='employees'; |
Greenplum DBA FAQ >
Greenplum DBA FAQ >
Size of partitioned tableposted Oct 17, 2013, 10:18 AM by Sachchida Ojha
|