Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] log sql?

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: mallah(at)trade-india(dot)com
Cc: xzilla(at)users(dot)sourceforge(dot)net, <pgman(at)candle(dot)pha(dot)pa(dot)us>,<pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] log sql?
Date: 2002-07-30 16:53:23
Message-ID: Pine.LNX.4.44.0207300952160.13200-100000@visor.corp.nextbus.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Yes indeed...the size has reach 9.6M in 15 minutes...it is spewing a lot of
info.  Hmmm....

Thanks,

L.
On Tue, 30 Jul 2002 mallah(at)trade-india(dot)com wrote:

> 
> 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(at)candle(dot)pha(dot)pa(dot)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(at)postgresql(dot)org)
> 
> 
> 
> -----------------------------------------
> Get your free web based email at trade-india.com.
>    "India's Leading B2B eMarketplace.!"
> http://www.trade-india.com/
> 
> 

-- 
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"Intelligence complicates. Wisdom simplifies." 
  -- Mason Cooley 


In response to

Responses

pgsql-admin by date

Next:From: Andrew SullivanDate: 2002-07-30 18:09:39
Subject: Re: [GENERAL] log sql?
Previous:From: mallahDate: 2002-07-30 16:50:55
Subject: Re: [GENERAL] log sql?

pgsql-general by date

Next:From: Tom LaneDate: 2002-07-30 17:45:40
Subject: Re: postgres 7.2.1 parse bug
Previous:From: mallahDate: 2002-07-30 16:50:55
Subject: Re: [GENERAL] log sql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group