From: | Jessica Dalman <jessica_dalman(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Finding slow queries? |
Date: | 2004-03-11 17:48:12 |
Message-ID: | 20040311174812.42028.qmail@web12906.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello,
I am a true newbie. I am brand new to postgres, and
databases in general. If anyone has any tips to offer,
I'd really appreciate it. I am trying to find which
queries are the slowest from a web site which runs on
top of postgres 7.4.1. I'm not sure what I need to
do, though. I set the log_min_duration_statement to
10000, but I don't see anything new being logged to
the pg.log. Are these queries logged somewhere else,
or do I need to change anything else in the conf?
Like I said, any help anyone could offer would be
great. I've inherited ownership of this web site just
because I'm the most technical person around the
nonprofit that I work for, but all that means is that
I can program the time into my VCR. :)
Thanks!
Jess
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster
http://search.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-11 18:37:15 | Re: Finding slow queries? |
Previous Message | jtlapp | 2004-03-11 14:20:38 | Re: installing postgresql |