PostgreSQL: How to show database size

Emanuel

July 06, 2022Software engineer at makandra GmbH

SELECT pg_size_pretty(pg_database_size('some-database'));

Example

SELECT pg_size_pretty(pg_database_size('cards_p'));
----------------
 13 GB
(1 row)

SELECT pg_database_size('cards_p');
 pg_database_size 
------------------
      13524832927
(1 row)

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

License for source code

Posted by Emanuel to makandra dev (2022-07-06 15:07)