PostgreSQL 查询所有表的记录数

方法一：（查询出来只是一个估计数值，与实际数据量不太一致）

select relname as 表名, reltuples as 记录数 
from pg_class 
where relkind = 'r' 
and relnamespace = (select oid from pg_namespace where nspname='指定schema') order by 记录数 desc;

实例：

select relname as 表名, reltuples as 记录数 
from pg_class 
where relkind = 'r' 
and relnamespace = (select oid from pg_namespace where nspname='npas') order by 记录数 desc;

但感觉查询出来的记录与实际相比不太一致

 

43423432432

方法二：

SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables 
where schemaname='npas'
ORDER BY n_live_tup DESC;

 

参考资料：

PostgreSQL 表 行数统计