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
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.
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.
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.
Gian Holland wrote:
I would like to display queries live
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.
···
On Jan 26, 2008 11:07 AM, Reid Thompson wrote:
While I'm not aware of a ruby library for this, the API for postgresql
certainly offers support for notifications:
The example linked from that page shows C code that gets notified on
actions on a particular table.
HTH,
Felix
···
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.