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
