bdelespierre · August 29, 2018 14:01
diff --git a/postgresql_table_rowcount.sql b/postgresql_table_rowcount.sql
 SELECT 
  nspname AS schemaname,relname,reltuples
 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;
	SELECT
	nspname AS schemaname,relname,reltuples
	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;