Jeff, You are CORRECT...my queries were going to /var/log/messages...had to get the Linux Admin to grant me READ access to the file... Thanks for your reply. Michelle. Jeff Frost wrote: > > Michelle, > > What platform are you on? If you're on linux, than logging to syslog will > likely show up in the /var/log/messages file. > > On Fri, 10 Aug 2007, smiley2211 wrote: > >> >> Hello all, >> >> I have ENABLED this 'log_min_duration_statement = 100" but I can't figure >> out WHERE it's writing the commands to ...I have it set to 'syslogs' but >> this file is 0 bytes :confused: >> >> Should I set other parameters in my postgresql.conf file??? >> >> Thanks...Michelle >> >> >> Bryan Murphy-3 wrote: >>> >>> we currently have logging enabled for all queries over 100ms, and keep >>> the last 24 hours of logs before we rotate them. I've found this tool >>> very helpful in diagnosing new performance problems that crop up: >>> >>> http://pgfouine.projects.postgresql.org/ >>> >>> Bryan >>> >>> On 8/8/07, Steinar H. Gunderson <sgunderson@xxxxxxxxxxx> wrote: >>>> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote: >>>>> I am trying to enable capturing of the submitted code via an >>>>> application...how do I do this in Postgres? Performance is SLOW on my >>>>> server and I have autovacuum enabled as well as rebuilt >>>> indexes...whatelse >>>>> should be looked at? >>>> >>>> Try "log_min_duration_statement = 100" in postgresql.conf; it will show >>>> all >>>> statements that take more than 100ms. Set to 0 to log _all_ statements, >>>> or >>>> -1 to turn the logging back off. >>>> >>>> /* Steinar */ >>>> -- >>>> Homepage: http://www.sesse.net/ >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 6: explain analyze is your friend >>>> >>> >>> ---------------------------(end of broadcast)--------------------------- >>> TIP 3: Have you checked our extensive FAQ? >>> >>> http://www.postgresql.org/docs/faq >>> >>> >> >> > > -- > Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > -- View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12099590 Sent from the PostgreSQL - performance mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
