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

2006-10-26 Thread Vivek Khera
On Oct 25, 2006, at 10:11 AM, A. Kretschmer wrote: Set this in your postgresql.conf: log_statement = all Reload the server, and then you can find all your statements in the log. or, preferably, on a per-connection basis, execute this SQL statement: set log_min_duration_statement = 0 the

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

2006-10-25 Thread A. Kretschmer
am Wed, dem 25.10.2006, um 15:56:17 +0200 mailte Nico Grubert folgendes: > 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

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

2006-10-25 Thread Merlin Moncure
On 10/25/06, Nico Grubert <[EMAIL PROTECTED]> 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