各个数据库查询数据库数据量

PostgreSQL转载https://www.xp.cn/b.php/54115.html

select relname as TABLE_NAME, reltuples as rowCounts from pg_class where relkind = 'r' order by rowCounts desc

MYSQL转载https://www.cnblogs.com/dingjiaoyang/p/9970610.html

use information_schema;
select sum(table_rows) from tables