On Sat, Jun 4, 2016 at 5:35 PM, sangeetha <tune2sangee@xxxxxxxxx> wrote:
SELECT pg_database_size('DB1') takes 60ms for 7948 kB size DB. Is there any
way to reduce the time taken or any other ways to find data base size?
What is the version of PostgreSQL you are using ?
You can execute the command "\l+" which will list all the databases and their sizes.
Or you can execute "\l+ <database-name>".
Regards,
Venkata B N
