ParametersQuery PlanningQuery Planning파라미터설명constraint_exclusioncpu_index_tuple_costcpu_operator_costcpu_tuple_costcursor_tuple_fractiondefault_statistics_targeteffective_cache_sizeenable_async_appendenable_bitmapscanenable_distinct_reorderingenable_eager_aggregatequery planner가 aggregation 일부를 join보다 먼저 수행하는 eager aggregation을 허용할지 결정한다.enable_gathermergeenable_group_by_reorderingenable_hashaggenable_hashjoinenable_incremental_sortenable_indexonlyscanenable_indexscanenable_materialenable_memoizeenable_mergejoinenable_nestloopenable_parallel_appendenable_parallel_hashenable_partition_pruningenable_partitionwise_aggregateenable_partitionwise_joinenable_presorted_aggregateenable_self_join_eliminationenable_seqscanenable_sortenable_tidscanfrom_collapse_limitgeqogeqo_effortgeqo_generationsgeqo_pool_sizegeqo_seedgeqo_selection_biasgeqo_thresholdjitjit_above_costjit_inline_above_costjit_optimize_above_costjoin_collapse_limitmin_eager_agg_group_sizeeager aggregation 적용을 고려하는 데 필요한 최소 평균 group 크기를 정한다.min_parallel_index_scan_sizemin_parallel_table_scan_sizeparallel_setup_costparallel_tuple_costplan_cache_moderandom_page_costrecursive_worktable_factorseq_page_cost