Wiki / Configuration Parameters
enable_partition_pruning
Enables or disables the query planner's ability to eliminate a partitioned table's partitions from query plans. This also controls the planner's ability to generate query plans which allow the query executor to remove (ignore) partitions during query execution. The default is on. See Section 5.12.4 for details.
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
- Allows the query planner and executor to compare partition bounds to conditions in the query to determine which partitions must be scanned.
- lang
- en
- max val
- Unknown
- metadata version
- 18
- min val
- Unknown
- name
- enable_partition_pruning
- short desc
- Enables plan-time and execution-time partition pruning.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- bool
Definition PG 18
Enables or disables the query planner's ability to eliminate a partitioned table's partitions from query plans. This also controls the planner's ability to generate query plans which allow the query executor to remove (ignore) partitions during query execution. The default is on. See Section 5.12.4 for details.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:a1f4af46c61e1d2c01bc73b67c7740d68ea241ccc933e01b1b0c835801ae65df
Text language: en · wiki-repair-20261023:a1f4af46c61e1d2c01bc73b67c7740d68ea241ccc933e01b1b0c835801ae65df