Re: [GENERAL] log sql?

Hi,

once you do that keep an eye over the log file size..
i rember messing up once on this,, postmaster will core dump
once size(log_file)> 2.1 GB.

regds
mallah.



> I'll try this.  The last time I turned the debugging level up, it
> generated massive amounts of info in the log file so I turned it off.
> I'll try this...
>
> Thanks!
>
> L.
> On 30 Jul 2002, Robert Treat wrote:
>
>> DEBUG_LEVEL (integer)
>>
>> The higher this value is set, the more "debugging" output of various
>> sorts is generated in the server log during operation. This option is
>> 0 by default, which means no debugging output. Values up to about 4
>> currently make sense.
>> DEBUG_PRINT_QUERY (boolean)
>> DEBUG_PRINT_PARSE (boolean)
>> DEBUG_PRINT_REWRITTEN (boolean)
>> DEBUG_PRINT_PLAN (boolean)
>> DEBUG_PRETTY_PRINT (boolean)
>>
>> These flags enable various debugging output to be sent to the server
>> log. For each executed query, prints either the query text, the
>> resulting parse tree, the query rewriter output, or the execution
>> plan. DEBUG_PRETTY_PRINT indents these displays to produce a more
>> readable but much longer output format. Setting DEBUG_LEVEL above zero
>> implicitly turns on some of these flags.
>> --
>> I'd recommend debug level 1 and print query true for starters. Also
>> remember that excessive debug logging can cause performance issues, so
>> keep an eye on things if you crank this up on a production server.
>>
>> Robert Treat
>>
>> On Tue, 2002-07-30 at 00:14, Bruce Momjian wrote:
>> > Andrew Sullivan wrote:
>> > > On Fri, Jul 26, 2002 at 03:27:45PM -0700, Laurette Cisneros wrote:
>> > > >
>> > > > Is there way to track each sql statement and the user for the
>> > > > server?
>> > >
>> > > Sort of.  Turn on query logging in the postgresql.conf file, and
>> > > also log connections and PID.  Then, you can track back by using
>> > > the PID, to discovere who logged in (and therefore, who issued
>> > > that query).
>> >
>> > Andrew, what postgresql.conf parameter is query logging.  I don't
>> > see it.  I see:
>> >
>> >     #log_connections = false
>> >     #log_timestamp = false
>> >     #log_pid = false
>> >
>> > --
>> >   Bruce Momjian                        |  http://candle.pha.pa.us
>> >   pgman@candle.pha.pa.us               |  (610) 853-3000
>> >   +  If your life is a hard drive,     |  830 Blythe Avenue
>> >   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
>> >   19026
>> >
>> > ---------------------------(end of
>> > broadcast)--------------------------- TIP 4: Don't 'kill -9' the
>> > postmaster
>>
>>
>>
>
> --
> Laurette Cisneros
> The Database Group
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> ----------------------------------
> "Intelligence complicates. Wisdom simplifies."
>  -- Mason Cooley
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: you can get off all lists
> at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/