查询数据表/库数据大小

PostgreSQL

查询单个数据库

select pg_size_pretty(pg_database_size('数据库名'))as size;

 

查询所有数据库(列表形式)

select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from pg_database; 

 

查询所有数据库总量

-- 自动指定单位
select pg_size_pretty (sum (pg_database_size(pg_database.datname))) AS size from pg_database; 

 

-- 手动指定单位
-- 默认结果是byte，除以两个1024换成MB，以此类推
select sum (pg_database_size(pg_database.datname))/1024/1024 || 'MB' AS size from pg_database; 

 

MySQL

SELECT
    TABLE_SCHEMA AS "数据库",
    sum( table_rows ) AS "记录数",
    concat( TRUNCATE ( sum( data_length ) / 1024 / 1024, 2 ), ' MB' ) / 1024 AS "数据容量（GB）",
    concat( TRUNCATE ( sum( index_length ) / 1024 / 1024, 2 ), 'MB' ) / 1024 AS "索引容量（GB）" 
FROM
    information_schema.TABLES 
WHERE
    table_schema = '数据库名';