Wiki / Configuration Parameters
default_statistics_target
Sets the default statistics target for table columns without a column-specific target set via ALTER TABLE SET STATISTICS. Larger values increase the time needed to do ANALYZE, but might improve the quality of the planner's estimates. The default is 100. For more information on the use of statistics by the PostgreSQL query planner, refer to Section 14.2.
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
- 100
- category
- Query Tuning / Other Planner Options
- context
- user
- documented
- true
- enumvals
- Unknown
- extra desc
- This applies to table columns that have not had a column-specific target set via ALTER TABLE SET STATISTICS.
- lang
- en
- max val
- 10000
- metadata version
- 18
- min val
- 1
- name
- default_statistics_target
- short desc
- Sets the default statistics target.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- integer
Definition PG 18
Sets the default statistics target for table columns without a column-specific target set via ALTER TABLE SET STATISTICS. Larger values increase the time needed to do ANALYZE, but might improve the quality of the planner's estimates. The default is 100. For more information on the use of statistics by the PostgreSQL query planner, refer to Section 14.2.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:888f3346d818d18df15429c9ab6d02806df2a112b0d64feca71cd8b74a654bd0
Text language: en · wiki-repair-20261023:888f3346d818d18df15429c9ab6d02806df2a112b0d64feca71cd8b74a654bd0