filter statements in logs - Mailing list pgsql-general

From Jaime Casanova
Subject filter statements in logs
Date
Msg-id 3073cc9b0811240843i12c0a8a0g881f4201fd4a5b99@mail.gmail.com
Whole thread Raw
Responses Re: filter statements in logs  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: literal limits in 8.3
Next
From: "Scott Marlowe"
Date:
Subject: Re: filter statements in logs