Query para obtener el numero de registros de cada tabla en postgresql

SELECT

nspname AS schemaname,relname,reltuples::integer

FROM pg_class C

LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)

WHERE

nspname NOT IN ('pg_catalog', 'information_schema') AND

relkind='r'

ORDER BY reltuples DESC;