logging queries
logging queries
От:
"Nick Fankhauser" <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? 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
От:
"Phil Geer" <philg@gearcc.com>
Дата:
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" To: "pgsql-admin" 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
От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
""Nick Fankhauser"" 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
От:
"Nick Fankhauser" <nickf@ontko.com>
Дата:
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"
> To: "pgsql-admin"
> 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)