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 web development

Do you need DevOps-experts?

Your development team has a full backlog? No time for infrastructure architecture? Our DevOps team is ready to support you!

  • We build reliable cloud solutions with Infrastructure as code
  • We are experts in security, Linux and databases
  • We support your dev team to perform
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)