Hi all,
I don't understand why this request take so long. Maybe I read the
analyse correctly but It seem that the first line(Nested Loop Left Join
...) take all the time. But I don't understand where the performance
problem is ??? All the time is passed in the first line ...
Thanks for
David Gagnon wrote:
- Index Scan using cr_pk on cr (cost=0.00..6.02 rows=1
width=828) (actual time=0.073..0.077 rows=1 loops=13587)
Index Cond: (((cr.crypnum)::text = 'M'::text) AND
(cr.crnum = outer.cscrnum))
Filter: ((crdate +
Bricklen Anderson [EMAIL PROTECTED] writes:
Your loops are what is causing the time spent.
eg. actual time=0.127..17.379 rows=1154 loops=8335) ==
8335*(17.379-0.127)/1000=143 secs (if my math is correct).
As for where the problem is, I think it's the horrid misestimate of the
number of