Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Merlin Moncure
On Thu, Apr 4, 2013 at 9:48 AM, Franck Routier wrote: > Hi, > > I have query that should be quick, and used to be quick, but is not > anymore... Explain analyze can be seen here http://explain.depesz.com/s/cpV > but it is fundamentaly quick : Total runtime: 0.545 ms. > > But query execution takes

Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Tom Lane
Franck Routier writes: > The request is not using any function. It looks like this: > [ unexciting query ] Hmph. Can't see any reason for that to take a remarkably long time to plan. Can you put together a self-contained test case demonstrating excessive planning time? What PG version is this,

Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread nik9000
On Apr 4, 2013, at 2:49 PM, Franck Routier wrote: > Le 04/04/2013 18:25, Tom Lane a écrit : >> Franck Routier writes: >>> Right, explain alone takes 3.6 seconds, so the time really seems to go >>> query planning... >> Well, you've not shown us the query, so it's all going to be >> speculation

Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Franck Routier
Le 04/04/2013 18:25, Tom Lane a écrit : Franck Routier writes: Right, explain alone takes 3.6 seconds, so the time really seems to go query planning... Well, you've not shown us the query, so it's all going to be speculation. But maybe you have some extremely expensive function that the plann

Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Tom Lane
Franck Routier writes: > Right, explain alone takes 3.6 seconds, so the time really seems to go > query planning... Well, you've not shown us the query, so it's all going to be speculation. But maybe you have some extremely expensive function that the planner is evaluating to fold to a constant

Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Franck Routier
Right, explain alone takes 3.6 seconds, so the time really seems to go query planning... Le 04/04/2013 17:01, Nikolas Everett a écrit : We had a problem where the actual query planning time blew up and took way more time then the query execution. We reproduced the problem by forming a new co

Re: [PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Nikolas Everett
We had a problem where the actual query planning time blew up and took way more time then the query execution. We reproduced the problem by forming a new connection and then just explaining the query. If that takes more than a couple of milliseconds you likely have the problem. The second plan w

[PERFORM] What happens between end of explain analyze and end of query execution ?

2013-04-04 Thread Franck Routier
Hi, I have query that should be quick, and used to be quick, but is not anymore... Explain analyze can be seen here http://explain.depesz.com/s/cpV but it is fundamentaly quick : Total runtime: 0.545 ms. But query execution takes 3.6 seconds. Only 12 rows are returned. Adding a limit 1 has no

Re: [PERFORM] Postgres upgrade, security release, where?

2013-04-04 Thread Ian Lawrence Barwick
2013/4/4 Mark Kirkwood : > On 02/04/13 21:47, Mark Kirkwood wrote: >> >> On 02/04/13 21:34, Dave Page wrote: >>> >>> On Mon, Apr 1, 2013 at 11:43 PM, Mark Kirkwood >>> wrote: On 02/04/13 13:55, Bruce Momjian wrote: > > > On Tue, Apr 2, 2013 at 09:40:07AM +0900, Ian Lawrence

Re: [PERFORM] Postgres upgrade, security release, where?

2013-04-04 Thread Mark Kirkwood
On 02/04/13 21:47, Mark Kirkwood wrote: On 02/04/13 21:34, Dave Page wrote: On Mon, Apr 1, 2013 at 11:43 PM, Mark Kirkwood wrote: On 02/04/13 13:55, Bruce Momjian wrote: On Tue, Apr 2, 2013 at 09:40:07AM +0900, Ian Lawrence Barwick wrote: Due to the security nature of the release, the sou