From: | imad <immaad(at)gmail(dot)com> |
---|---|
To: | sbaskar <sbaskar(at)adventnet(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Please let me know the table details |
Date: | 2006-11-18 19:21:55 |
Message-ID: | 1f30b80c0611181121u19e51834qaff72931cd3f9ccd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Check out pg_stats and pg_statistic in details for different sort of statistics.
Look for databases in pg_database, schemas in pg_namespace, tables in
pg_class etc.
Tell exactly about the meta info you want to get the name of catalog!
--Imad
www.EnterpriseDB.com
On 11/18/06, sbaskar <sbaskar(at)adventnet(dot)com> wrote:
> Hi,
> I am working on database monitoring tool using Java, JDBC. We plan to
> monitor pgSQL also. But i need some details like, where i can get
> information such as Connection time, Connection statistics, Database
> Information, Transaction statistics, Cache details from pgSQL and what
> are the metrics that i can monitor. I mean, in which database tables
> these details are stored and how can i get it.
>
> Any help on this would be greatly Appreciated.
>
> Thanks,
> Baskar.S
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
From | Date | Subject | |
---|---|---|---|
Next Message | Charlie Kelly | 2006-11-19 19:45:48 | Use Driver to Create database? |
Previous Message | sbaskar | 2006-11-18 11:46:35 | Please let me know the table details |