sql查询数据库大小

-- 获取整个数据库的大小（以MB为单位）
SELECT table_schema AS 'Database',
       SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)'
FROM information_schema.TABLES
WHERE table_schema = 'your_database_name'
GROUP BY table_schema;

-- 获取整个数据库的大小（以MB为单位）
SELECT pg_database.datname AS db_name,
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database
WHERE pg_database.datname = 'your_database_name';

-- 获取整个数据库的大小（以MB为单位）
SELECT 
    DB_NAME(database_id) AS DatabaseName,
    CAST(SUM(size * 8.00 / 1024) AS DECIMAL(18,2)) AS [Size (MB)]
FROM 
    sys.master_files
WHERE 
    type = 0  -- 0 = rows, 1 = log
GROUP BY 
    database_id
HAVING 
    DB_NAME(database_id) = 'your_database_name';