public inbox for [email protected]
help / color / mirror / Atom feedpg_database_size
3+ messages / 3 participants
[nested] [flat]
* pg_database_size
@ 2016-06-04 07:35 sangeetha <[email protected]>
2016-06-04 08:10 ` Re: pg_database_size Venkata Balaji N <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: sangeetha @ 2016-06-04 07:35 UTC (permalink / raw)
To: pgsql-performance
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?
Thanks and Regards,
S.Sangeetha
--
View this message in context: http://postgresql.nabble.com/pg-database-size-tp5906449.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_database_size
2016-06-04 07:35 pg_database_size sangeetha <[email protected]>
@ 2016-06-04 08:10 ` Venkata Balaji N <[email protected]>
2016-06-14 21:00 ` Re: pg_database_size Jim Nasby <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Venkata Balaji N @ 2016-06-04 08:10 UTC (permalink / raw)
To: sangeetha <[email protected]>; +Cc: pgsql-performance
On Sat, Jun 4, 2016 at 5:35 PM, sangeetha <[email protected]> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_database_size
2016-06-04 07:35 pg_database_size sangeetha <[email protected]>
2016-06-04 08:10 ` Re: pg_database_size Venkata Balaji N <[email protected]>
@ 2016-06-14 21:00 ` Jim Nasby <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Jim Nasby @ 2016-06-14 21:00 UTC (permalink / raw)
To: Venkata Balaji N <[email protected]>; sangeetha <[email protected]>; +Cc: pgsql-performance
On 6/4/16 3:10 AM, Venkata Balaji N wrote:
>
> On Sat, Jun 4, 2016 at 5:35 PM, sangeetha <[email protected]
> <mailto:[email protected]>> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2016-06-14 21:00 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-06-04 07:35 pg_database_size sangeetha <[email protected]>
2016-06-04 08:10 ` Venkata Balaji N <[email protected]>
2016-06-14 21:00 ` Jim Nasby <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox