↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

enable_indexonlyscan

Enables or disables the query planner's use of index-only-scan plan types (see Section 11.9). The default is on. The enable_indexscan setting must also be enabled to have the query planner consider index-only-scans.

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_indexonlyscan
short desc
Enables the planner's use of index-only-scan plans.
source
pg-settings-source-snapshot
unit
Unknown
vartype
bool

Definition PG 18

Enables or disables the query planner's use of index-only-scan plan types (see Section 11.9). The default is on. The enable_indexscan setting must also be enabled to have the query planner consider index-only-scans.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:c5189d150d24b7e3346d21178bdf72088ff40ae34c21db40c4d591a98e7f62c7

Text language: en · wiki-repair-20261023:c5189d150d24b7e3346d21178bdf72088ff40ae34c21db40c4d591a98e7f62c7