Re: Logging SQL queries? - Mailing list pgsql-general

From Phil Geer
Subject Re: Logging SQL queries?
Date
Msg-id 001c01c22d4b$56e8a700$4ac16dd8@offback2000
Whole thread Raw
In response to Logging SQL queries?  (Steve Lane <slane@fmpro.com>)
Responses Re: Logging SQL queries?
List pgsql-general
SET DEBUG_PRINT_QUERY TO 1
it might be
SET DEBUG_PRINT_QUERY TO ON

Had to do this a couple weeks back to debug something.

That should work it'll print your queries to the standard log file but the
experts may have a way to get it into another file for you.

Good Luck
Phil
----- Original Message -----
From: "Steve Lane" <slane@fmpro.com>
To: "PostgreSQL General Mailing List" <pgsql-general@postgresql.org>
Sent: Tuesday, July 16, 2002 11:40 PM
Subject: [GENERAL] Logging SQL queries?


> Hello all:
>
> I want to do some profiling of a large application I run under postgres.
> Ideally I'd like to capture just the queries that are submitted to the
> database. It would be rather annoying to have to log them from the
> application layer, so I'm hoping there's some suitable log-level setting
on
> the back end that can do this. Something that could log only the queries
to
> a different specific file would be excellent, but any flavor of this would
> be good.
>
> Thanks,
>
> steve
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: COPY seems to work, but no data in the table
Next
From: Justin Clift
Date:
Subject: Re: ? about Installation of Postgresql