Re: How check execution plan of a function

From: "Sabin Coanda" <sabin(dot)coandaSPAMPROTECTION(at)deuromedia(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How check execution plan of a function
Date: 2010-04-09 13:18:25
Message-ID: hpn9i7$1dku$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2010-04-09 13:52:00 Re: How check execution plan of a function
Previous Message RD黄永卫 2010-04-09 07:23:02 About “context-switching issue on Xeon” test case ？