如下：

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