Query Tuning / Planner Method Configuration

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_group_by_reordering

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables reordering of GROUP BY keys.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_group_by_reordering

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,off
Parameter type dynamic
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 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_presorted_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's ability to produce plans that provide presorted input for ORDER BY / DISTINCT aggregate functions. Allows the query planner to build plans that provide presorted input for aggregate functions with an ORDER BY / DISTINCT clause. When disabled, implicit sorts are always performed during execution.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_presorted_aggregate

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_presorted_aggregate

Attribute Value
Category Query Tuning / Planner Method Configuration
Description Enables the planner's ability to produce plans that provide presorted input for ORDER BY / DISTINCT aggregate functions. Allows the query planner to build plans that provide presorted input for aggregate functions with an ORDER BY / DISTINCT clause. When disabled, implicit sorts are always performed during execution.
Data type boolean
Default value on
Allowed values on,off
Parameter type dynamic
Documentation enable_presorted_aggregate

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