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_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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |
Parameter type | read-only |
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 |