gp查看数据库，schema,表的大小

合集 - Greenplum(3)

1.gp数据清理2024-10-082.gp查看表的分布键2024-10-08

3.gp查看数据库，schema,表的大小2024-10-08

收起

查询数据库大小
select pg_size_pretty(pg_database_size('mdmaster_baosheng_test1'));

查询所有表大小 --针对大表处理
select schemaname,relname, pg_size_pretty(pg_relation_size(relid)),* from pg_stat_user_tables order by pg_relation_size(relid) desc ;
查询所有schema大小
SELECT schema_name, pg_size_pretty(sum(table_size)::bigint) as "disk space", round((sum(table_size) / pg_database_size(current_database())) * 100,2) as "percent(%)" FROM ( SELECT pg_catalog.pg_namespace.nspname as schema_name, pg_total_relation_size(pg_catalog.pg_class.oid) as table_size FROM pg_catalog.pg_class JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid ) t GROUP BY schema_name ORDER BY "percent(%)" desc ;