Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] PgSQL Monitoring( Please let me know the table details )

From: David Fetter <david(at)fetter(dot)org>
To: sbaskar <sbaskar(at)adventnet(dot)com>
Cc: pgsql-jdbc-owner(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org,pgsql-general(at)postgresql(dot)org
Subject: Re: [JDBC] PgSQL Monitoring( Please let me know the table details )
Date: 2007-01-05 15:10:43
Message-ID: 20070105151042.GG1562@fetter.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

pgsql-jdbc by date

Next:From: Do, Leon (Leon)Date: 2007-01-05 15:47:28
Subject: Re: need to update TimestampUtils code
Previous:From: Ravi PeriasamyDate: 2007-01-05 14:48:47
Subject: Re: issues with Statement.getTimestamp(int, Calendar)

pgsql-general by date

Next:From: David FetterDate: 2007-01-05 15:27:00
Subject: Re: Any form of connection-level "session variable" ?
Previous:From: imageguyDate: 2007-01-05 14:59:18
Subject: Re: Database versus filesystem for storing images

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group