Finding large tables in PostgreSQL
Quick SQL code to help determine large tables in PostgreSQL
select tablename,pg_size_pretty(pg_relation_size(tablename::name)) from pg_tables where schemaname = 'public' order by pg_relation_size(tablename::name) desc limit 30;
