Home > mailing lists

Re: pg_database_size - Mailing list pgsql-performance

From	Venkata Balaji N
Subject	Re: pg_database_size
Date	June 4, 2016 11:10:28
Msg-id	CAEyp7J-sHQfJx-vm_0CGDJcLpRUGiOBA59+a3nwf2spaYA+TjQ@mail.gmail.com Whole thread Raw
In response to	pg_database_size (sangeetha <tune2sangee@gmail.com>)
Responses	Re: pg_database_size (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List	pgsql-performance

On Sat, Jun 4, 2016 at 5:35 PM, sangeetha <tune2sangee@gmail.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

From: sangeetha
Date: 04 June 2016, 10:36:06
Subject: pg_database_size

From: Kevin Grittner
Date: 04 June 2016, 16:40:00
Subject: Re: index fragmentation on insert-only table with non-unique column