jneight · August 12, 2013 08:54
diff --git a/row_count_all_tables b/row_count_all_tables
 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;