Postgres Pro
Downloads
Home   >   mailing lists

Re: How check execution plan of a function - Mailing list pgsql-performance

From Sabin Coanda
Subject Re: How check execution plan of a function
Date
Msg-id hpn9i7$1dku$1@news.hub.org
Whole thread Raw
In response to How check execution plan of a function  ("Sabin Coanda" <sabin.coandaSPAMPROTECTION@deuromedia.ro>)
Responses Re: How check execution plan of a function  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: RD黄永卫
Date:
Subject: About “context-switching issue on Xeon” test case ？
Next
From: Robert Haas
Date:
Subject: Re: significant slow down with various LIMIT