Postgres Professional
   

Re: pgqueryspy

From: Jeff Trout
Subject: Re: pgqueryspy
Date: ,
Msg-id: E669B8FF-2C4D-4BA0-8212-220AD7193104@torgo.978.org
(view: Whole thread, Raw)
In response to: Re: pgqueryspy  (David Fetter)
List: pgsql-advocacy

Tree view

pgqueryspy  (Christopher Kings-Lynne, )
 Re: pgqueryspy  (David Fetter, )
  Re: pgqueryspy  (Neil Conway, )
  Re: pgqueryspy  (Jeff Trout, ) 
On Jun 27, 2006, at 1:19 PM, David Fetter wrote:

> On Tue, Jun 27, 2006 at 04:47:24PM +0800, Christopher Kings-Lynne
> wrote:
>> This seems new:
>>
>> http://dotnot.org/blog/archives/2006/02/22/spying-on-postgresql/
>
> Have you used it?  Does it work?  Is it as non-invasive as the author
> claims?
>
I wrote a tool a year or two ago that does this sort of thing.
Uses libpcap to find PG packets and decodes v2 and v3 protocols.

http://pgfoundry.org/projects/pgspy

Not the best code, but it worked super good for my uses. Can also
provide TPS information as well.

--
Jeff Trout <>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/

pgsql-advocacy by date:

Previous:
From: Robert Bernier
Date:
Subject: Re: [Conference-attendees] Need Help with Equipment for Anniversary
Next:
From: Chris Browne
Date:
Subject: Re: [Conference-attendees] Need Help with Equipment for Anniversary