On Sat, Jun 4, 2016 at 5:35 PM, sangeetha <tune2sangee(at)gmail(dot)com> 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