Re: Filtering queries by IP

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Filtering queries by IP
Дата
Msg-id 1390248774.2769.42.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Filtering queries by IP  (Leonardo M. Ramé <l.rame@griensu.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: incrementing without violating a constraint
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Filtering queries by IP