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 <jobyjob...@gmail.com> > Sorry ! The command I use is 'EXPLAIN ANALYZE' > I can't do better ... > > 2011/3/1 <t...@fuzzy.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 >> >> >
