统计testdb库中各索引占用磁盘大小: \c testdb select schemaname,relname,indexrelname,pg_size_pretty( pg_relation_size(relid)) from pg_stat_user_indexes order by pg_relation_size(relid) desc limit 10 ; 1. 2.
--查看数据库大小,不计算索引selectpg_size_pretty(pg_database_size('mydb')); --查看数据库大小,包含索引selectpg_size_pretty(pg_total_size('mydb')); --查看表中索引大小selectpg_size_pretty(pg_indexes_size('test_1')); --查看表大小,不包括索引selectpg_size_pretty(pg_relation_size('test_...
select pg_size_pretty(pg_database_size('mydb')); --查看数据库大小,包含索引 select pg_size_pretty(pg_total_size('mydb')); --查看表中索引大小 select pg_size_pretty(pg_indexes_size('test_1')); --查看表大小,不包括索引 select pg_size_pretty(pg_relation_size('test_1')); --or \...
统计各数据库占用磁盘大小: 代码语言:javascript 复制 SELECTd.datnameASName,pg_catalog.pg_get_userbyid(d.datdba)ASOwner,CASEWHENpg_catalog.has_database_privilege(d.datname,'CONNECT')THENpg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname))ELSE'No Access'ENDASSIZEFROMpg_catalog.pg...