Read more

PostgreSQL: Show size of all databases

Thomas Eisenbarth
January 14, 2016Software engineer at makandra GmbH

Use this:

SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER by size_in_mb DESC;
Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more Show archive.org snapshot

Want to see database sizes in MySQL ?

Posted by Thomas Eisenbarth to makandra dev (2016-01-14 15:52)