| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | "Leonardo M(dot)" Ramé <l(dot)rame(at)griensu(dot)com> |
| Cc: | PostgreSql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Filtering queries by IP |
| Date: | 2014-01-20 20:12:54 |
| Message-ID: | 1390248774.2769.42.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2014-01-21 02:20:52 | Re: Filtering queries by IP |
| Previous Message | Tom Lane | 2014-01-20 15:43:59 | Re: incrementing without violating a constraint |