Re: Monitoring Postgres - Get the SQL queries which are sent to postgres

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Nico Grubert" <nicogrubert(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Monitoring Postgres - Get the SQL queries which are sent to postgres
Date: 2006-10-25 14:11:02
Message-ID: b42b73150610250711p1b54b042rcefd8904444c91c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/25/06, Nico Grubert <nicogrubert(at)gmail(dot)com> wrote:
> Dear list members,
>
> I have a web application running that is connected to my postgres
> database. This web application builds dynamically SQL queries and
> queries the postgres database. I would like to see these SQL queries.
> How can I do this? Is there a way to monitor the SQL queries which are
> sent to my postgres database?

see logging features in postgresql.conf. I suggest redirecting stderr
to pg_log and playing with rotation features.

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-10-25 14:11:44 Re: Monitoring Postgres - Get the SQL queries which are sent to postgres
Previous Message Andrew Sullivan 2006-10-25 14:06:57 Re: password cookie