Re: [PERFORM] Problem analyzing explain analyze output

2005-10-23 Thread Guillaume Smet
Steinar, which seems to make sense; you have one run of about 257ms, plus 514 runs taking about 0.035ms each (ie. about 18ms), which should add up to become about 275ms (which is close enough to the reality of 281ms). Yep. The line that disturbed me was the bitmap index scan with a cost of "a

Re: [PERFORM] Problem analyzing explain analyze output

2005-10-23 Thread Steinar H. Gunderson
On Mon, Oct 24, 2005 at 01:53:59AM +0200, Guillaume Smet wrote: > I don't understand why I have the Nested Loop at line 19 with an actual > time of 254.292..257.328 because I can't find anywhere the line taking > this 254 ms. You don't have a nested loop with that time; however, you have > ->

[PERFORM] Problem analyzing explain analyze output

2005-10-23 Thread Guillaume Smet
Hi all, I'm currently testing PostgreSQL 8.1 beta3 and I have a problem with a EXPLAIN ANALYZE output. You can find it attached. I don't understand why I have the Nested Loop at line 19 with an actual time of 254.292..257.328 because I can't find anywhere the line taking this 254 ms. Is it a