Re: Two different execution plans for similar requests

Me again ! I have checked this question of 'explain analyze' and I
understand now.

When the problem occured I have run a 'EXPLAIN'

I have run the request again to open this case using 'EXPLAIN ANALYZE' but I
didn't reproduce the case. That's why I sent the other trace but it doesn't
countain the information you are asking for.
So Tomas, you were right !

All apologies !!!!! (I'm confused)

But the problem still not resolved .....

2011/3/1 Joby Joba <jobyjoba59(at)gmail(dot)com>

> Sorry ! The command I use is 'EXPLAIN ANALYZE'
> I can't do better ...
>
> 2011/3/1 <tv(at)fuzzy(dot)cz>
>
>> > I've already used an 'EXPLAIN ANALYZE' to post the message. So I don't
>>
>> > clearly understand what you are expecting for, when you tell me to
>> provide
>> > 'EXPLAIN ANALYZE' (please excuse me for the misunderstood)
>>
>> No, you haven't. You've provided 'EXPLAIN' output, but that just prepares
>> an execution plan and displays it. So it shows just estimates of row
>> counts etc. and not actual values.
>>
>> Do the same thing but use 'EXPLAIN ANALYZE' instead of 'EXPLAIN' - it will
>> run the query and provide more details about it (run time for each node,
>> actual number of rows etc.).
>>
>> Anyway the sudden changes of estimated costs are suspicious ...
>>
>> Tomas
>>
>>
>