From: | Mark Rae <m(dot)rae(at)inpharmatica(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: frustration with database size <long> |
Date: | 2002-01-23 10:03:48 |
Message-ID: | 3C4E8A84.73D06C6@inpharmatica.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Einar Karttunen wrote:
> On 21.01.02 14:40 -0600(+0000), Thomas F. O'Connell wrote:
> > well, that certainly is data. but what does it mean?
> > what does this query actually spell out?
> > to what do relkind and relpages refere?
> > just curious.
> >
> It's documented in the developers guide:
> http://www.postgresql.org/idocs/index.php?catalog-pg-class.html
I have some CGI scripts which I use to produce web pages
for monitoring the size of my databases. which uses similar
queries.
I was going to be packaging this up nicely at some point, but if
you think it might be of some use you can get a copy of it as it
currently stands from
http://www.rahu.demon.co.uk/pgstat.tgz
You should be able to untar it into your cgi-bin directory, and then
change the user/password etc. in PGSConfig.pm
You can then access it as
http://machinename/cgi-bin/pgstat/dblist.pl
-Mark
--
Mark Rae Tel: +44(0)20 7074 4648
Inpharmatica Fax: +44(0)20 7074 4700
m(dot)rae(at)inpharmatica(dot)co(dot)uk http://www.inpharmatica.co.uk/
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry Alyabyev | 2002-01-23 10:39:27 | Permissions on non-owned database |
Previous Message | Holger Krug | 2002-01-23 07:31:37 | Re: implemention of calls to stored procs. |