Laur's blog
Sign in Subscribe

size

A collection of 1 post
Postgres: Show Schema Sizes in a Database
database

Postgres: Show Schema Sizes in a Database

While loading a large database from files to a Postgres schema, I found very useful to know how much space on disk it actually occupies (just in case I need to re-size the disk). I found this answer online: SELECT schema_name, pg_size_pretty(sum(table_size)::bigint) as
Oct 2, 2014 1 min read
Page 1 of 1
Laur's blog © 2025
  • Sign up
Powered by Ghost