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 > > -- View this message in context: http://www.nabble.com/How-to-ENABLE-SQL-capturing----tf4238694.html#a12096180 Sent from the PostgreSQL - performance mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
