How To Show Size Of PostgreSQL Database

IT Support Forum Forums Databases PostgreSQL General Discussion How To Show Size Of PostgreSQL Database

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 3 weeks, 4 days ago.

  • Author
    Posts
  • #2400

    Webmaster
    Keymaster

    Need to find out the size of your Postgres database on the disk? Here’s a query to run to show the size of the Postgres database:

    SELECT pg_size_pretty(pg_database_size(current_database())) as size;

    Run that in PG Admin against the database you want to know the size of, and it will return the result showing the size in KB, MB or GB.

You must be logged in to reply to this topic.