PostgreSQL: 10 biggest tables by disk size, plus a row count estimate

gistfile1.sql

with row_counts as (SELECT reltuples, relname FROM pg_class)
select
  table_name,
  pg_size_pretty(pg_total_relation_size(quote_ident(table_name))) as total_size,
  row_counts.reltuples::decimal(38,0) as row_count
from information_schema.tables
join row_counts on table_name = row_counts.relname
where table_schema = 'public'
order by pg_total_relation_size(quote_ident(table_name)) desc
limit 10;