方法一:(查询出来只是一个估计数值,与实际数据量不太一致)
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;
参考资料: