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