postgres=# select version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 16.8 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 14.2.1 20250110 (Red Hat 14.2.1-7), 64-bit
(1 行记录)
postgres=# select distinct category,count(name)
from pg_settings
where category like '%Planner%'
group by category;
category | count
---------------------------------------------+-------
Query Tuning / Other Planner Options | 8
Query Tuning / Planner Cost Constants | 13
Query Tuning / Planner Method Configuration | 21
(3 行记录)
postgres=# select name from pg_settings
where category like 'Query Tuning / Other Planner Options';
name
----------------------------
constraint_exclusion
cursor_tuple_fraction
default_statistics_target
from_collapse_limit
jit
join_collapse_limit
plan_cache_mode
recursive_worktable_factor
(8 行记录)
postgres=# select name from pg_settings
where category like 'Query Tuning / Planner Cost Constants';
name
------------------------------
cpu_index_tuple_cost
cpu_operator_cost
cpu_tuple_cost
effective_cache_size
jit_above_cost
jit_inline_above_cost
jit_optimize_above_cost
min_parallel_index_scan_size
min_parallel_table_scan_size
parallel_setup_cost
parallel_tuple_cost
random_page_cost
seq_page_cost
(13 行记录)
postgres=# select name from pg_settings
where category like 'Query Tuning / Planner Method Configuration';
name
--------------------------------
enable_async_append
enable_bitmapscan
enable_gathermerge
enable_hashagg
enable_hashjoin
enable_incremental_sort
enable_indexonlyscan
enable_indexscan
enable_material
enable_memoize
enable_mergejoin
enable_nestloop
enable_parallel_append
enable_parallel_hash
enable_partition_pruning
enable_partitionwise_aggregate
enable_partitionwise_join
enable_presorted_aggregate
enable_seqscan
enable_sort
enable_tidscan
(21 行记录)