GP 性能：磁盘空间

--gp查看表占用磁盘空间

select stodsize from gp_toolkit where upper(sotdschemaname) =? and upper(sotdtablename)=? ; --超级用户gpadmin

select pg_relation_size(upper('<table>')); --表所在模式

select distinct pg_relation_size(upper(<table>)) from pg_tables t where t.schemaname=lower('<schema>');--普通用户

 

参考:

GreenPlum_常用数据库命令