sql查询服务器所有数据库大小

SELECT table_schema AS 'Database', 
       SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)' 
FROM information_schema.tables 
GROUP BY table_schema;

SELECT pg_database.datname AS 'Database',
       pg_size_pretty(pg_database_size(pg_database.datname)) AS 'Size'
FROM pg_database;

SELECT DB_NAME(database_id) AS 'Database',
       CAST(SUM(size * 8 / 1024.0) AS DECIMAL(10, 2)) AS 'Size (MB)'
FROM sys.master_files
WHERE type = 0
GROUP BY database_id;

SELECT tablespace_name AS 'Tablespace',
       SUM(bytes) / 1024 / 1024 AS 'Size (MB)'
FROM dba_data_files
GROUP BY tablespace_name;