Ben <bench(at)silentmedia(dot)com> writes:
> Here's what explain tells me:
> explain SELECT * FROM jennyann where target like '/music/%' order by "LogTime" limit 1000;
> NOTICE: QUERY PLAN:
> Sort (cost=119.88..119.88 rows=2085 width=136)
> -> Index Scan using jennyann_target_key on jennyann (cost=0.00..4.94 rows=2085 width=136)
How many records are actually getting sorted here --- ie, how many would
you get back if you didn't have the LIMIT? It seems to be estimating
2085, but I suspect that must be wildly wrong ...
regards, tom lane