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@adventnet.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
>