filter statements in logs

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема filter statements in logs
Дата
Msg-id 3073cc9b0811240843i12c0a8a0g881f4201fd4a5b99@mail.gmail.com
обсуждение исходный текст
Ответы Re: filter statements in logs  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
Hi,

A client has a web system that uses ADODB for php, and that driver is
executing "select version()", "SET DATESTYLE TO 'ISO'" and at least
one or two more statements a *lot* of times (almost 1000000 times in 3
hours, and this is just "select version()"), i tried to understand why
but it seems it is for knowing the correct way of looking in catalogs.

But this is just noise in the logs. And when i try to use pgFouine to
analyze logs it shouts because of the size of them, almost 450Mb in a
few hours.

My question: is there a way to avoid logging some predefined statements?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: literal limits in 8.3
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: filter statements in logs