Postgres Pro
Downloads
Home   >   mailing lists

Re: Monitoring Postgres - Get the SQL queries which are sent to postgres - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Monitoring Postgres - Get the SQL queries which are sent to postgres
Date
Msg-id b42b73150610250711p1b54b042rcefd8904444c91c8@mail.gmail.com
Whole thread Raw
In response to Monitoring Postgres - Get the SQL queries which are sent to postgres  (Nico Grubert <nicogrubert@gmail.com>)
List pgsql-general
Tree view 
On 10/25/06, Nico Grubert <nicogrubert@gmail.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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: password cookie
Next
From: "A. Kretschmer"
Date:
Subject: Re: Monitoring Postgres - Get the SQL queries which are sent to postgres