Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Your queries are executing different plans. The first one is executing a nested loop join which filters out 1,246,035,384 intermediate rows. The second one is executing a index join which doesn't filter out any intermediate rows at all. This seems like it was caused either by the scientist_labs_pkey index not being there in the first trial or just random luck due to a difference in statistics.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: