List tables sorted by size with rows count by schema (PostgreSQL only)

list-tables-by-size.sql

SELECT table_name,
       pg_relation_size(quote_ident(table_name)) AS size,
       n_live_tup AS rows
  FROM information_schema.tables AS it
  JOIN pg_stat_user_tables AS ut
    ON it.table_name = ut.relname
   AND it.table_schema = ut.schemaname
 WHERE table_schema = 'public'
 ORDER BY 2 DESC;