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

查看数据库大小

SELECT pg_size_pretty(pg_database_size('postgres'));
1

查看表大小

SELECT pg_size_pretty(pg_relation_size('table_test'));  
1

查看索引大小

SELECT pg_size_pretty(pg_relation_size('table_test_pkey'));
1

查看表空间大小

SELECT pg_size_pretty(pg_tablespace_size('pg_default')); 
1

查看表大小（包括索引）

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

查看表（包含索引）大小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;
1
2
3
4
5
6
7
8
9
10
11