Re: logging queries

Here is a link to the doc you need.

http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING

DEBUG_PRINT_QUERY (boolean)
DEBUG_PRINT_PARSE (boolean)
DEBUG_PRINT_REWRITTEN (boolean)
DEBUG_PRINT_PLAN (boolean)
DEBUG_PRETTY_PRINT (boolean)

Hope this helps
Phil
----- Original Message -----
From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Sent: Monday, September 23, 2002 6:05 PM
Subject: [ADMIN] logging queries

> Hi-
>
> I'd like to set the logging or debug level so that the text of the queries
> that are executed show up in the log file. It seems to me that I recall
this
> being discussed before, but I can't find any specific references in the
> runtime-config portion of the docs.
>
> Can someone tell me if this is possible & if so, what runtime settings are
> needed?
>
> Thanks
>
> -Nick
>
> --------------------------------------------------------------------------
> Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
> Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>