Query Tuning / Planner Method Configuration

  • Article
  • 02/12/2025
Choose a PostgreSQL version

enable_async_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of async append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_async_append

enable_bitmapscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of bitmap-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_bitmapscan

enable_gathermerge

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of gather merge plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_gathermerge

enable_hashagg

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hashed aggregation plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashagg

enable_hashjoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hash join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashjoin

enable_incremental_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of incremental sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_incremental_sort

enable_indexonlyscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-only-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexonlyscan

enable_indexscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexscan

enable_material

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of materialization.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_material

enable_memoize

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of memoization.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_memoize

enable_mergejoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of merge join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_mergejoin

enable_nestloop

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of nested loop join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_nestloop

enable_parallel_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_append

enable_parallel_hash

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel hash plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_hash

enable_partition_pruning

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables plan-time and execution-time partition pruning.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_partition_pruning

enable_partitionwise_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_aggregate

enable_partitionwise_join

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_join

enable_seqscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of sequential-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_seqscan

enable_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of explicit sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_sort

enable_tidscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of TID scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_tidscan

enable_async_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of async append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_async_append

enable_bitmapscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of bitmap-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_bitmapscan

enable_gathermerge

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of gather merge plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_gathermerge

enable_hashagg

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hashed aggregation plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashagg

enable_hashjoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hash join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashjoin

enable_incremental_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of incremental sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_incremental_sort

enable_indexonlyscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-only-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexonlyscan

enable_indexscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexscan

enable_material

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of materialization.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_material

enable_memoize

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of memoization.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_memoize

enable_mergejoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of merge join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_mergejoin

enable_nestloop

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of nested loop join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_nestloop

enable_parallel_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_append

enable_parallel_hash

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel hash plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_hash

enable_partition_pruning

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables plan-time and execution-time partition pruning.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_partition_pruning

enable_partitionwise_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_aggregate

enable_partitionwise_join

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_join

enable_seqscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of sequential-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_seqscan

enable_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of explicit sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_sort

enable_tidscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of TID scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_tidscan

enable_async_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of async append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_async_append

enable_bitmapscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of bitmap-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_bitmapscan

enable_gathermerge

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of gather merge plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_gathermerge

enable_hashagg

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hashed aggregation plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashagg

enable_hashjoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hash join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashjoin

enable_incremental_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of incremental sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_incremental_sort

enable_indexonlyscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-only-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexonlyscan

enable_indexscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexscan

enable_material

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of materialization.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_material

enable_memoize

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of memoization.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_memoize

enable_mergejoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of merge join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_mergejoin

enable_nestloop

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of nested loop join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_nestloop

enable_parallel_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_append

enable_parallel_hash

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel hash plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_hash

enable_partition_pruning

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables plan-time and execution-time partition pruning.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_partition_pruning

enable_partitionwise_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_aggregate

enable_partitionwise_join

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_join

enable_seqscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of sequential-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_seqscan

enable_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of explicit sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_sort

enable_tidscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of TID scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_tidscan

enable_bitmapscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of bitmap-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_bitmapscan

enable_gathermerge

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of gather merge plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_gathermerge

enable_hashagg

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hashed aggregation plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashagg

enable_hashjoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hash join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashjoin

enable_incremental_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of incremental sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_incremental_sort

enable_indexonlyscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-only-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexonlyscan

enable_indexscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexscan

enable_material

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of materialization.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_material

enable_mergejoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of merge join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_mergejoin

enable_nestloop

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of nested loop join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_nestloop

enable_parallel_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_append

enable_parallel_hash

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel hash plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_hash

enable_partition_pruning

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables plan-time and run-time partition pruning.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_partition_pruning

enable_partitionwise_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_aggregate

enable_partitionwise_join

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_join

enable_seqscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of sequential-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_seqscan

enable_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of explicit sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_sort

enable_tidscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of TID scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_tidscan

enable_bitmapscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of bitmap-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_bitmapscan

enable_gathermerge

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of gather merge plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_gathermerge

enable_hashagg

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hashed aggregation plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashagg

enable_hashjoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hash join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashjoin

enable_indexonlyscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-only-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexonlyscan

enable_indexscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexscan

enable_material

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of materialization.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_material

enable_mergejoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of merge join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_mergejoin

enable_nestloop

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of nested loop join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_nestloop

enable_parallel_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_append

enable_parallel_hash

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel hash plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_hash

enable_partition_pruning

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables plan-time and run-time partition pruning.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_partition_pruning

enable_partitionwise_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_aggregate

enable_partitionwise_join

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_join

enable_seqscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of sequential-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_seqscan

enable_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of explicit sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_sort

enable_tidscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of TID scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_tidscan

enable_bitmapscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of bitmap-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_bitmapscan

enable_gathermerge

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of gather merge plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_gathermerge

enable_hashagg

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hashed aggregation plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashagg

enable_hashjoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of hash join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_hashjoin

enable_indexonlyscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-only-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexonlyscan

enable_indexscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of index-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_indexscan

enable_material

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of materialization.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_material

enable_mergejoin

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of merge join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_mergejoin

enable_nestloop

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of nested loop join plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_nestloop

enable_parallel_append

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel append plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_append

enable_parallel_hash

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of parallel hash plans.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_parallel_hash

enable_partition_pruning

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enable plan-time and run-time partition pruning.
Data type boolean
Default value on
Allowed values on
Parameter type read-only
Documentation enable_partition_pruning

enable_partitionwise_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise grouping or aggregation, which allows grouping or aggregation on a partitioned tables performed separately for each partition.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_aggregate

enable_partitionwise_join

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables or disables the query planner's use of partitionwise join, which allows a join between partitioned tables to be performed by joining the matching partitions.
Data type boolean
Default value off
Allowed values on,off
Parameter type dynamic
Documentation enable_partitionwise_join

enable_seqscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of sequential-scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_seqscan

enable_sort

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of explicit sort steps.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_sort

enable_tidscan

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's use of TID scan plans.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_tidscan