找出Postgres中占用磁盘最多的表

SELECT schemaname,
       relname,
       pg_size_pretty(pg_table_size(relid))
from pg_stat_user_tables
order by pg_table_size(relid) desc ,schemaname;