How To Show Size Of PostgreSQL Database Posted on by Webmaster IT Support Forum › Forums › Databases › PostgreSQL › General Discussion › How To Show Size Of PostgreSQL Database Tagged: pg_database_size, pg_size_pretty This topic has 0 replies, 1 voice, and was last updated 4 years, 7 months ago by Webmaster. Viewing 0 reply threads Author Posts February 28, 2019 at 10:41 am #2400 WebmasterKeymaster 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. Author Posts Viewing 0 reply threads You must be logged in to reply to this topic. Log In Username: Password: Keep me signed in Log In