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 |
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru