select relname , pg_relation_filepath(relname||' ') , pg_size_pretty(pg_total_relation_size(relname||' ')) from pg_class c join pg_namespace n on n.oid = c.relnamespace where relkind='r' and nspname = 'public' order by pg_total_relation_size(relname||' ') DESC ;