NEW: Paste your query and schema data and we give you the best index. Launch pganalyze Index Advisor

EXPLAIN - Join Nodes

This section describes the three types of join mechanisms in Postgres.

Joins are performed on two tables at a time; if more tables are joined together, the output of one join is treated as input to a subsequent join. When joining a large number of tables, the genetic query optimizer settings may affect what combinations of joins are considered.


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