PgSQL Monitoring( Please let me know the table details )

From: sbaskar <sbaskar(at)adventnet(dot)com>
To: pgsql-jdbc-owner(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: PgSQL Monitoring( Please let me know the table details )
Date: 2007-01-05 04:25:05
Message-ID: 459DD321.90909@adventnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Best 2007-01-05 05:24:16 Database Corruption - last chance recovery options?
Previous Message Joe Conway 2007-01-05 02:22:29 Re: Any form of connection-level "session variable" ?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2007-01-05 05:28:52 Re: Support for DatabaseMetadata: getCatalogName, getTableName,
Previous Message Kris Jurka 2007-01-05 00:35:25 Re: help with front/backend datatype converting