Postgresql：查看表、索引、表空间大小，top 10

查看数据库大小

SELECT pg_size_pretty(pg_database_size('postgres'));

查看表大小

SELECT pg_size_pretty(pg_relation_size('table_test'));  

查看索引大小

SELECT pg_size_pretty(pg_relation_size('table_test_pkey'));

查看表空间大小

SELECT pg_size_pretty(pg_tablespace_size('pg_default')); 

查看表大小（包括索引）

 SELECT pg_size_pretty(pg_total_relation_size(cast('text_table' as text)));

查看表（包含索引）大小Top 10

select 
	tablename,
	pg_size_pretty(size) 
from 
(select 
	tablename,
	pg_total_relation_size(cast(tablename as text)) as size 
from pg_tables 
where schemaname = 'public' -- 指定schema
) as tmp 
order by size desc limit 30;