greenplum查看表和库的大小

查看表的大小

select pg_size_pretty(pg_relation_size('tb_cfg_city'));

查看库的大小

select pg_size_pretty(pg_total_relation_size('tb_cfg_city'));

查看某个数据库的大小

select pg_size_pretty(pg_database_size('ltjt_dev'));

查看所有库的大小

select datname,pg_size_pretty(pg_database_size(datname)) from pg_database;

查看数据分布情况

select gp_segment_id,count(*) from tb_cfg_city group by gp_segment_id order by 1;

查看磁盘空间

select dfhostname, dfspace,dfdevice from gp_toolkit.gp_disk_free order by dfhostname;