[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

monitoring postgres transaction

Gian Holland

1/26/2008 3:05:00 PM

[Note: parts of this message were removed to make it a legal post.]

Hi I would like to monitor postgres transactions in a realtime fashion, is
there a library I can use to help me facilitate this functionality
5 Answers

Reid Thompson

1/26/2008 4:07:00 PM

0

Gian Holland wrote:
> Hi I would like to monitor postgres transactions in a realtime fashion, is
> there a library I can use to help me facilitate this functionality
>
Explain what you mean by monitor.

Gian Holland

1/26/2008 6:15:00 PM

0

[Note: parts of this message were removed to make it a legal post.]

I would like to display queries live

On Jan 26, 2008 11:07 AM, Reid Thompson <reid.thompson@ateb.com> wrote:

> Gian Holland wrote:
> > Hi I would like to monitor postgres transactions in a realtime fashion,
> is
> > there a library I can use to help me facilitate this functionality
> >
> Explain what you mean by monitor.
>
>
>

Bob Gustafson

1/26/2008 6:26:00 PM

0

You could use Wireshark to look at the packets going from your
application to the postgresql server.

Wireshark has a 'real time' mode. It also has parsers built-in which
interpret the bits in each packet.

Bob G

On Jan 26, 2008, at 12:15, Gian Holland wrote:

> I would like to display queries live
>
> On Jan 26, 2008 11:07 AM, Reid Thompson <reid.thompson@ateb.com>
> wrote:
>
>> Gian Holland wrote:
>>> Hi I would like to monitor postgres transactions in a realtime
>>> fashion,
>> is
>>> there a library I can use to help me facilitate this functionality
>>>
>> Explain what you mean by monitor.
>>
>>
>>

Felix Windt

1/26/2008 6:45:00 PM

0

On Sun, 2008-01-27 at 03:26 +0900, Bob Gustafson wrote:
> You could use Wireshark to look at the packets going from your
> application to the postgresql server.
>
> Wireshark has a 'real time' mode. It also has parsers built-in which
> interpret the bits in each packet.
>
> Bob G
>
> On Jan 26, 2008, at 12:15, Gian Holland wrote:
>
> > I would like to display queries live
> >
> > On Jan 26, 2008 11:07 AM, Reid Thompson <reid.thompson@ateb.com>
> > wrote:
> >
> >> Gian Holland wrote:
> >>> Hi I would like to monitor postgres transactions in a realtime
> >>> fashion,
> >> is
> >>> there a library I can use to help me facilitate this functionality
> >>>
> >> Explain what you mean by monitor.

While I'm not aware of a ruby library for this, the API for postgresql
certainly offers support for notifications:

http://www.postgresql.org/docs/8.1/static/libpq-n...

The example linked from that page shows C code that gets notified on
actions on a particular table.

HTH,

Felix

Reid Thompson

1/27/2008 5:13:00 PM

0

Gian Holland wrote:
> I would like to display queries live
>
> On Jan 26, 2008 11:07 AM, Reid Thompson wrote:
>
>> Gian Holland wrote:
>>> Hi I would like to monitor postgres transactions in a realtime fashion,
>> is
>>> there a library I can use to help me facilitate this functionality
>>>
>> Explain what you mean by monitor.
>>
>>
>>
>

With the proper configuration flags turned on, you can query internal postgresql
table(s) for running queries. But, short lived queries will probably be in and
out of the table(s) too fast to be seen.