Query Tuning / Other Planner Options

2025/05/19

constraint_exclusion

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the query planner's use of table constraints to optimize queries.
Data type	enumeration
Default value	`partition`
Allowed values	`partition,on,off`
Parameter type	dynamic
Documentation	constraint_exclusion

cursor_tuple_fraction

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type	numeric
Default value	`0.1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	cursor_tuple_fraction

default_statistics_target

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the default statistics target for table columns without a column-specific target.
Data type	integer
Default value	`100`
Allowed values	`1-10000`
Parameter type	dynamic
Documentation	default_statistics_target

from_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	from_collapse_limit

jit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Determines whether JIT compilation may be used by PostgreSQL.
Data type	boolean
Default value	`off`
Allowed values	`on, off`
Parameter type	dynamic
Documentation	jit

join_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	join_collapse_limit

plan_cache_mode

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the planner's selection of custom or generic plan.
Data type	enumeration
Default value	`auto`
Allowed values	`auto,force_generic_plan,force_custom_plan`
Parameter type	dynamic
Documentation	plan_cache_mode

recursive_worktable_factor

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the average size of a recursive query's working table.
Data type	numeric
Default value	`10`
Allowed values	`10`
Parameter type	read-only
Documentation	recursive_worktable_factor

constraint_exclusion

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the query planner's use of table constraints to optimize queries.
Data type	enumeration
Default value	`partition`
Allowed values	`partition,on,off`
Parameter type	dynamic
Documentation	constraint_exclusion

cursor_tuple_fraction

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type	numeric
Default value	`0.1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	cursor_tuple_fraction

default_statistics_target

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the default statistics target for table columns without a column-specific target.
Data type	integer
Default value	`100`
Allowed values	`1-10000`
Parameter type	dynamic
Documentation	default_statistics_target

from_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	from_collapse_limit

jit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Determines whether JIT compilation may be used by PostgreSQL.
Data type	boolean
Default value	`off`
Allowed values	`on, off`
Parameter type	dynamic
Documentation	jit

join_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	join_collapse_limit

plan_cache_mode

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the planner's selection of custom or generic plan.
Data type	enumeration
Default value	`auto`
Allowed values	`auto,force_generic_plan,force_custom_plan`
Parameter type	dynamic
Documentation	plan_cache_mode

recursive_worktable_factor

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the average size of a recursive query's working table.
Data type	numeric
Default value	`10`
Allowed values	`10`
Parameter type	read-only
Documentation	recursive_worktable_factor

constraint_exclusion

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the query planner's use of table constraints to optimize queries.
Data type	enumeration
Default value	`partition`
Allowed values	`partition,on,off`
Parameter type	dynamic
Documentation	constraint_exclusion

cursor_tuple_fraction

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type	numeric
Default value	`0.1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	cursor_tuple_fraction

default_statistics_target

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the default statistics target for table columns without a column-specific target.
Data type	integer
Default value	`100`
Allowed values	`1-10000`
Parameter type	dynamic
Documentation	default_statistics_target

from_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	from_collapse_limit

jit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Determines whether JIT compilation may be used by PostgreSQL.
Data type	boolean
Default value	`off`
Allowed values	`on, off`
Parameter type	dynamic
Documentation	jit

join_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	join_collapse_limit

plan_cache_mode

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the planner's selection of custom or generic plan.
Data type	enumeration
Default value	`auto`
Allowed values	`auto,force_generic_plan,force_custom_plan`
Parameter type	dynamic
Documentation	plan_cache_mode

constraint_exclusion

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the query planner's use of table constraints to optimize queries.
Data type	enumeration
Default value	`partition`
Allowed values	`partition,on,off`
Parameter type	dynamic
Documentation	constraint_exclusion

cursor_tuple_fraction

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type	numeric
Default value	`0.1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	cursor_tuple_fraction

default_statistics_target

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the default statistics target for table columns without a column-specific target.
Data type	integer
Default value	`100`
Allowed values	`1-10000`
Parameter type	dynamic
Documentation	default_statistics_target

from_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	from_collapse_limit

jit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Determines whether JIT compilation may be used by PostgreSQL.
Data type	boolean
Default value	`off`
Allowed values	`on, off`
Parameter type	dynamic
Documentation	jit

join_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	join_collapse_limit

plan_cache_mode

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the planner's selection of custom or generic plan.
Data type	enumeration
Default value	`auto`
Allowed values	`auto,force_generic_plan,force_custom_plan`
Parameter type	dynamic
Documentation	plan_cache_mode

constraint_exclusion

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the query planner's use of table constraints to optimize queries.
Data type	enumeration
Default value	`partition`
Allowed values	`partition,on,off`
Parameter type	dynamic
Documentation	constraint_exclusion

cursor_tuple_fraction

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type	numeric
Default value	`0.1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	cursor_tuple_fraction

default_statistics_target

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the default statistics target for table columns without a column-specific target.
Data type	integer
Default value	`100`
Allowed values	`1-10000`
Parameter type	dynamic
Documentation	default_statistics_target

from_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	from_collapse_limit

jit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Determines whether JIT compilation may be used by PostgreSQL.
Data type	boolean
Default value	`off`
Allowed values	`on, off`
Parameter type	dynamic
Documentation	jit

join_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	join_collapse_limit

plan_cache_mode

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the planner's selection of custom or generic plan.
Data type	enumeration
Default value	`auto`
Allowed values	`auto,force_generic_plan,force_custom_plan`
Parameter type	dynamic
Documentation	plan_cache_mode

constraint_exclusion

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Controls the query planner's use of table constraints to optimize queries.
Data type	enumeration
Default value	`partition`
Allowed values	`partition,on,off`
Parameter type	dynamic
Documentation	constraint_exclusion

cursor_tuple_fraction

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
Data type	numeric
Default value	`0.1`
Allowed values	`0-1`
Parameter type	dynamic
Documentation	cursor_tuple_fraction

default_statistics_target

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the default statistics target for table columns without a column-specific target.
Data type	integer
Default value	`100`
Allowed values	`1-10000`
Parameter type	dynamic
Documentation	default_statistics_target

from_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	The planner will merge sub-queries into upper queries upto this limit in FROM clause. Smaller values reduce planning time but might yield inferior query plans.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	from_collapse_limit

jit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Determines whether JIT compilation may be used by PostgreSQL.
Data type	boolean
Default value	`off`
Allowed values	`on, off`
Parameter type	dynamic
Documentation	jit

join_collapse_limit

Attribute	Value
Category	Query Tuning / Other Planner Options
Description	Sets the FROM-list size beyond which JOIN constructs are not flattened.
Data type	integer
Default value	`8`
Allowed values	`1-2147483647`
Parameter type	dynamic
Documentation	join_collapse_limit