PostgreSQL sizes of tables

select tablename, pg_size_pretty(pg_relation_size(tablename)) as data, pg_size_pretty(pg_total_relation_size(tablename)) as total from (select tablename from pg_tables where schemaname = current_schema()) as foo order by pg_total_relation_size(tablename) desc;

This was posted 1 year ago. It has 7 notes.
  1. karlvr posted this