We just released a new major feature on pganalyze: Automated EXPLAIN plan analysis and plan visualization.Learn more

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 →