Postgres DB utils SQL scripts

utils-db-postgresql.sql

-- DB size in bytes
SELECT pg_size_pretty( pg_database_size('dbname') );

-- Table size in bytes
SELECT pg_size_pretty( pg_total_relation_size('tablename') );


-- All table sizes sorted by size desc
SELECT table_name, pg_size_pretty( pg_relation_size(quote_ident(table_name)) )
  FROM information_schema.tables
 WHERE table_schema = 'public'
 ORDER BY pg_relation_size(quote_ident(table_name)) DESC;