From: | Ashish Karalkar <ashish(dot)karalkar(at)netcore(dot)co(dot)in> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Database size in specific metrics |
Date: | 2010-08-30 13:12:04 |
Message-ID: | 4C7BAE24.4050809@netcore.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
*for i in `psql -t -c "select datname from pg_catalog.pg_database d" |
grep -v template0 | grep -v template1`; do echo $i;psql -d $i -t -c
"SELECT pg_database_size('$i')/1024/1024 As fulldbsizeInMB;"; done*
On 08/30/2010 02:25 PM, Machiel Richards wrote:
> Good day all
>
> I am really hoping that someone can help me out here.
>
>
> I have a server (as example) with 24 postgresql databases running
> on it. Each database differs in size from a couple of kb to a couple
> of Gb.
>
> When using these different sizes to try and create charts which
> will show the database growth, I am having some issues.
>
>
> The reason for this is that all the values are stored / noted
> in the spreadsheets with the specific metric such as kb, mb,etc...
> next to it in order to differentiate between them.
>
>
> In order to be able to create the chart, the values however
> must only contain the numeric values with no metric values.
>
>
> I am running the following commands to retrieve the database
> sizes:
>
> *for i in `psql -t -c "select datname from
> pg_catalog.pg_database d" | grep -v template0 | grep -v template1`; do
> echo $i;psql -d $i -t -c "SELECT
> pg_size_pretty(pg_database_size('$i')) As fulldbsize;"; done*
>
> My question:
>
> Does anybody know of a method to retrieve the sizes,
> however , by specifying in which metric it should be displayed? (i.e.
> 1Gb will be returned as 1024Mb).
>
>
> I would really appreciate it if someone can assist with this.
>
>
> Regards
> Machiel
>
>
--
With Regards
Ashish Karalkar
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2010-08-30 15:15:39 | Partitions and the optimizer. |
Previous Message | Terry Lee Tucker | 2010-08-30 10:37:53 | Re: Starting postgres at boot |