From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | smiley2211 <smiley2211(at)yahoo(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: How to ENABLE SQL capturing??? |
Date: | 2007-08-10 20:10:02 |
Message-ID: | Pine.LNX.4.64.0708101309230.1940@discord.home.frostconsultingllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)bigfoot(dot)com> 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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-08-10 20:36:07 | Re: Dell Hardware Recommendations |
Previous Message | Heikki Linnakangas | 2007-08-10 20:05:13 | Re: Bitmap Index Scan optimization opportunity |