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:

Which results in a list like:

postgres-info

HTH,

PS: All credit goes to this StackOverflow answer!


A little experiment: If you find this post and ad below useful, please check the ad out :-)




One thought on “Postgres: Show Schema Sizes in a Database

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to top