filter statements in logs

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: filter statements in logs
Date: 2008-11-24 16:43:41
Message-ID: 3073cc9b0811240843i12c0a8a0g881f4201fd4a5b99@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-11-24 17:04:55 Re: filter statements in logs
Previous Message Tom Lane 2008-11-24 15:45:42 Re: literal limits in 8.3