select
relname as tableNmae,
reltuples as rowCounts
from pg_class
where relkind = 'r'
and relnamespace = (select oid from pg_namespace where nspname='public')
order by rowCounts desc;
查询结果如下:
select
relname as tableNmae,
reltuples as rowCounts
from pg_class
where relkind = 'r'
and relnamespace = (select oid from pg_namespace where nspname='public')
order by rowCounts desc;
查询结果如下: