不知道是哪个大神写的,因为我从别人的blog看到的时候,别人也注明说是忘记哪个大神写的。所以,对原创者很抱歉,不能写出来源了。
以下为SQL执行结果:
[img]http://dl2.iteye.com/upload/attachment/0122/1558/467626dc-084e-3acc-9f63-d6bcddf5769d.jpg[/img]
SELECT
schemaname as schema,
tablename as table_name,
pg_size_pretty(pg_relation_size(schemaname || '.' || tablename)) AS size_p,
pg_total_relation_size(schemaname || '.' || tablename) AS siz,
pg_size_pretty(pg_total_relation_size(schemaname || '.' || tablename)) AS 表总大小,
pg_total_relation_size(schemaname || '.' || tablename) - pg_relation_size(schemaname || '.' || tablename) AS 索引大小,
(100*(pg_total_relation_size(schemaname || '.' || tablename) - pg_relation_size(schemaname || '.' || tablename)))/CASE WHEN pg_total_relation_size(schemaname || '.' || tablename) = 0 THEN 1 ELSE pg_total_relation_size(schemaname || '.' || tablename) END || '%' AS index_pct
FROM pg_tables
ORDER BY siz DESC
以下为SQL执行结果:
[img]http://dl2.iteye.com/upload/attachment/0122/1558/467626dc-084e-3acc-9f63-d6bcddf5769d.jpg[/img]