PostgreSQL常用查看命令

標籤：code   order   style   class   post   ret   int   spn   names   

1. 查看當前庫sehcma大小,並按schema排序

SELECT schema_name,     pg_size_pretty(sum(table_size)::bigint) as "disk space",    (sum(table_size) / pg_database_size(current_database())) * 100        as "percent"FROM (     SELECT pg_catalog.pg_namespace.nspname as schema_name,         pg_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) tGROUP BY schema_nameORDER BY schema_name;

 

PostgreSQL常用查看命令