高斯查询

# 查询所有库大小
SELECT 
    datname AS database_name,
    pg_size_pretty(pg_database_size(datname)) AS size
FROM 
    pg_database
ORDER BY 
    pg_database_size(datname) DESC;

# 查询指定库大小
SELECT pg_size_pretty(pg_database_size('aaa')) AS database_size;