How To Show Size Of PostgreSQL Database

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

Viewing 0 reply threads
  • 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.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.