| 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: | Whole Thread | Raw Message | 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 |