找出占用空间最大的目录

查看磁盘占用率

df -h

从大到小排序，查看前二十个

du -ahx / | sort -rh | head -20

postgreSql 查看占用空间

查看占用空间较大的数据库

SELECT datname, pg_size_pretty(pg_database_size(datname))
FROM pg_database
ORDER BY pg_database_size(datname) DESC;

查看占用空间较大的表

SELECT relname AS table_name,
       pg_size_pretty(pg_total_relation_size(relid)) AS total_size,
       pg_size_pretty(pg_relation_size(relid)) AS table_size,
       pg_size_pretty(pg_indexes_size(relid)) AS index_size
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC
LIMIT 60;