PostgreSQL常用查看命令
时间：2021-07-01 10:21:17
帮助过：25人阅读
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
) t
GROUP BY schema_name
ORDER BY schema_name;
PostgreSQL常用查看命令
标签：code order style class post ret int spn names
