To find total size of partition table on Postgresql, one can run following query. Note this show table size only

select pg_size_pretty(sum(pg_relation_size(inhrelid::regclass))) from pg_inherits where inhparent='<schema>.<table>'::regclass;
 pg_size_pretty
----------------
 3810 GB