Re: Filtering queries by IP - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Filtering queries by IP
Date
Msg-id 1390248774.2769.42.camel@localhost.localdomain
Whole thread Raw
In response to Filtering queries by IP  (Leonardo M. Ramé <l.rame@griensu.com>)
List pgsql-general
On Mon, 2014-01-20 at 10:21 -0300, Leonardo M. Ramé wrote:
> Hi, I'm trying to find the cause of slow performance on some screens of
> an application. To do that, I would like to be able to log all the
> queries made by an specific IP addres, is this possible?.
>

Not by default, but you can use this extension to do that:

http://pgxn.org/dist/pg_log_userqueries/1.0.0/

And I'm interested to know if it helped you or not, and how I can make
it even better.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: incrementing without violating a constraint
Next
From: Sergey Konoplev
Date:
Subject: Re: Filtering queries by IP