On 6/4/16 3:10 AM, Venkata Balaji N wrote:
On Sat, Jun 4, 2016 at 5:35 PM, sangeetha <tune2sangee@xxxxxxxxx <mailto: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>".
Depending on your needs, you could also take the sum of pg_class.relpages and multiply that by BLKSZ.
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
