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
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 |