Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached

[Michael Lewis]

Using auto_explain may be needed to catch the plan when it is slow, if the
other suggestions don't resolve things for you.