Wiki / Configuration Parameters
enable_self_join_elimination
Enables or disables the query planner's optimization which analyses the query tree and replaces self joins with semantically equivalent single scans. Takes into consideration only plain tables. The default is on.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- on
- category
- Query Tuning / Planner Method Configuration
- context
- user
- documented
- true
- enumvals
- Unknown
- extra desc
- Unknown
- lang
- en
- max val
- Unknown
- metadata version
- 18
- min val
- Unknown
- name
- enable_self_join_elimination
- short desc
- Enables removal of unique self-joins.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- bool
Definition PG 18
Enables or disables the query planner's optimization which analyses the query tree and replaces self joins with semantically equivalent single scans. Takes into consideration only plain tables. The default is on.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:9603c21ab834e877dbae51cc88dbaccf50dcb51f420a5eb10b08c2e0f4432ab1
Text language: en · wiki-repair-20261023:9603c21ab834e877dbae51cc88dbaccf50dcb51f420a5eb10b08c2e0f4432ab1