Check out our latest eBook: "Efficient Search in Rails with Postgres". We've updated our Terms of Service and Privacy Policy, effective Jan 30, 2021.

EXPLAIN - Nested Loop Join

Description:

For each row in the outer table, iterate through all the rows in the inner table and see if they match the join condition. If the inner relation can be scanned with an index, that can improve the performance of a Nested Loop Join. This is generally an inefficient way to process joins but is always available and sometimes may be the only option.

Important Fields:

  • Filter
  • Inner Unique
  • Join Filter
  • Join Type
  • Rows Removed by Filter
  • Rows Removed by Join Filter


Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →