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