select-row-counts-all-tables-quickly.sql

-- quickly select the estimated row counts, using reltuples, across all tables
-- sort the results by descending size, and table names alphabetically
--
-- This relies on the table having been recently analyzed.
SELECT relname as "Table"
     , to_char(reltuples::bigint, '9,999,999,999,999') AS "~Rows"
  FROM pg_class
 WHERE relname NOT LIKE 'pg%'
   AND relkind = 'r'
ORDER BY 2 DESC, 1;