Re: Problems with inconsistant query performance.

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Problems with inconsistant query performance.
Дата
Msg-id 20060928161549.GN34238@nasby.net
обсуждение исходный текст
Ответ на Re: Problems with inconsistant query performance.  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: Problems with inconsistant query performance.  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-performance
On Thu, Sep 28, 2006 at 11:28:43AM -0400, Bill Moran wrote:
> In response to Matthew Schumacher <matt.s@aptalaska.net>:
> >
> > What I really need is a way to profile my proc when it runs slow so that
> > I can resolve which of the queries is really slow.  Anyone with an idea
> > on how to do this?
>
> You could turn on statement logging and duration logging.  This would
> give you a record of when things run and how long they take.  A little
> work analyzing should show you which queries are running when your
> favorite query slows down.

By default, that doesn't help you debug what's happening inside a
function, because you only get the call to the function. I don't know if
you can increase verbosity to combat that.

Something else to consider is that gettimeofday() on some platforms is
painfully slow, which could completely skew all your numbers.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Problems with inconsistant query performance.
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Performace Optimization for Dummies