# GP统计每个schema的大小 - GB
select
schemaname,
round(sum(pg_total_relation_size(schemaname||'.'||tablename))/1024/1024/1024,2) "GB"
from pg_tables
where schemaname in ('card','center','cif')
group by 1;
# GP统计多个schema的总大小 - GB
select
round(sum(pg_total_relation_size(schemaname||'.'||tablename))/1024/1024/1024,2) "GB"
from pg_tables
where schemaname in ('card','center','cif');