SEO

#1 (**permalink**) 04-16-2008, 12:30 AM

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 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#2 (**permalink**) 04-16-2008, 12:30 AM

On Fri, Jan 05, 2007 at 09:55:05AM +0530, sbaskar 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.

See <http://www.postgresql.org/docs/current/static/catalogs.html>.

Cheers,
Dave.
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

PgSQL Monitoring( Please let me know the table details )