Thread: logging queries

logging queries

From
"Nick Fankhauser"
Date:
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@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/


Re: logging queries

From
"Phil Geer"
Date:
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@ontko.com>
To: "pgsql-admin" <pgsql-admin@postgresql.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@ontko.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
>


Re: logging queries

From
"Gaetano Mendola"
Date:
""Nick Fankhauser"" <nickf@ontko.com> wrote in message
news:NEBBLAAHGLEEPCGOBHDGOEHAFNAA.nickf@ontko.com...
> 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?

Well,
in    postgresql.conf     put
debug_level = 2
debug_print_query = true


Ciao
Gaetano



Re: logging queries

From
"Nick Fankhauser"
Date:
Thanks Phil- That was exactly what I needed.

A couple of notes that might help others-

My goal was to get all of the SQL statements from a JDBC front-end to be
logged as they are executed in the postgres.log file (and not in the
syslog.) Adding the following to my postgresql.conf did the job:

syslog = 0
silent_mode = off
debug_print_query = on
debug_pretty_print = on

I'm not sure if the pretty print option does anything for the SQL, but it
didn't hurt.

-Nick


> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Phil Geer
> Sent: Monday, September 23, 2002 7:25 PM
> To: nickf@ontko.com; pgsql-admin
> Subject: Re: [ADMIN] 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@ontko.com>
> To: "pgsql-admin" <pgsql-admin@postgresql.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@ontko.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
>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)