Re: Logging SQL queries?

You can use the -d option with your start script

On Wed, 17 Jul 2002, Phil Geer wrote:

> 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(at)fmpro(dot)com>
> To: "PostgreSQL General Mailing List" <pgsql-general(at)postgresql(dot)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
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>