Re: How check execution plan of a function

От: Kevin Grittner
Тема: Re: How check execution plan of a function
Дата: ,
Msg-id: 4BC2DEBC020000250003071A@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: How check execution plan of a function  ("Sabin Coanda")
Список: pgsql-performance

Скрыть дерево обсуждения

How check execution plan of a function  ("Sabin Coanda", )
 Re: How check execution plan of a function  ("Sabin Coanda", )
 Re: How check execution plan of a function  (Andy Colson, )
 Re: How check execution plan of a function  (Andy Colson, )
 Re: How check execution plan of a function  ("Sabin Coanda", )
  Re: How check execution plan of a function  ("Kevin Grittner", )

"Sabin Coanda" <> wrote:

> I have just a function returning a cursor based on a single coplex
> query. When I check the execution plan of that query it takes
> about 3 seconds. Just when it is used inside the function it
> freezes.
>
> This is the problem, and this is the reason I cannot imagine what
> is happen.
>
> Also I tried to recreate the function as it was before when it run
> in 3 seconds, but I cannot make it to run properly now.

You've given three somewhat confusing and apparently contradictory
descriptions of the problem or problems you've had with slow queries
-- all on one thread.  You would probably have better luck if you
start with one particular issue and provided more of the information
suggested here:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

If we can solve one problem, perhaps the resolution to the others
will become apparent; otherwise follow up with the next.

-Kevin


В списке pgsql-performance по дате сообщения:

От: "Kevin Grittner"
Дата:
Сообщение: Re: How check execution plan of a function
От: norn
Дата:
Сообщение: Re: significant slow down with various LIMIT