Number of rows in base tables

Copy SQL

ANALYZE;
SELECT n.nspname AS schema_name, c.relname AS table_name, c.reltuples
FROM pg_catalog.pg_class c
INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
INNER JOIN pg_catalog.pg_authid u ON u.oid = c.relowner
WHERE c.relkind IN ('r') 
AND (n.nspname = 'public' OR u.rolname <> 'postgres') 
ORDER BY reltuples DESC, n.nspname, c.relname;