查询数据库大小
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 ;