name optional unit comment
autovacuum_analyze_scale_factor [0-1] Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.
autovacuum_analyze_threshold [0-2147483647] Minimum number of tuple inserts, updates, or deletes prior to analyze.
autovacuum_freeze_max_age [200000000-1500000000] Age at which to autovacuum a table to prevent transaction ID wraparound.
autovacuum_max_workers [5-20] Sets the maximum number of simultaneously running autovacuum worker processes.
autovacuum_vacuum_cost_delay [-1-100] ms Vacuum cost delay in milliseconds, for autovacuum.
autovacuum_vacuum_cost_limit [-1-10000] Vacuum cost amount available before napping, for autovacuum.
autovacuum_vacuum_scale_factor [0-1] Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
autovacuum_vacuum_threshold [0-2147483647] Minimum number of tuple updates or deletes prior to vacuum.
checkpoint_completion_target [0-1] Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.
checkpoint_timeout [30-86400] s Sets the maximum time between automatic WAL checkpoints.
checkpoint_warning [30-2147483647] s Enables warnings if checkpoint segments are filled more frequently than this.
commit_delay [0-100000] Sets the delay in microseconds between transaction commit and flushing WAL to disk.
commit_siblings [0-1000] Sets the minimum concurrent open transactions before performing commit_delay.
default_statistics_target [1-10000] Sets the default statistics target.
default_transaction_deferrable [on|off] Sets the default deferrable status of new transactions.
enable_bitmapscan [on|off] Enables the planner's use of bitmap-scan plans.
enable_gathermerge [on|off] Enables the planner's use of gather merge plans.
enable_hashagg [on|off] Enables the planner's use of hashed aggregation plans.
enable_hashjoin [on|off] Enables the planner's use of hash join plans.
enable_indexonlyscan [on|off] Enables the planner's use of index-only-scan plans.
enable_indexscan [on|off] Enables the planner's use of index-scan plans.
enable_material [on|off] Enables the planner's use of materialization.
enable_mergejoin [on|off] Enables the planner's use of merge join plans.
enable_nestloop [on|off] Enables the planner's use of nested-loop join plans.
enable_parallel_append [on|off] Enables the planner's use of parallel append plans.
enable_parallel_hash [on|off] Enables the planner's use of parallel hash plans.
enable_partition_pruning [on|off] Enable plan-time and run-time partition pruning.
enable_partitionwise_aggregate [on|off] Enables partitionwise aggregation and grouping.
enable_partitionwise_join [on|off] Enables partitionwise join.
enable_seqscan [on|off] Enables the planner's use of sequential-scan plans.
enable_sort [on|off] Enables the planner's use of explicit sort steps.
enable_tidscan [on|off] Enables the planner's use of TID scan plans.
gin_fuzzy_search_limit [0-2147483647] Sets the maximum allowed result for exact search by GIN.
gin_pending_list_limit [64-2147483647] kB Sets the maximum size of the pending list for GIN index.
auto_explain.log_analyze [on|off] Use EXPLAIN ANALYZE for plan logging.
lock_timeout [0-2147483647] ms Sets the maximum allowed duration of any wait for a lock.
log_autovacuum_min_duration [-1-2147483647] ms Sets the minimum execution time above which autovacuum actions will be logged.
log_checkpoints [on|off] Logs each checkpoint.
log_connections [on|off] Logs each successful connection.
log_disconnections [on|off] Logs end of a session, including duration.
log_min_duration_statement [-1-2147483647] ms Sets the minimum execution time above which statements will be logged.
log_statement [none,ddl,mod,all] Sets the type of statements logged.
log_temp_files [-1-2147483647] kB Log the use of temporary files larger than this number of kilobytes.
max_standby_archive_delay [-1-2147483647] ms Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
max_standby_streaming_delay [-1-2147483647] ms Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
max_sync_workers_per_subscription [0-262143] Maximum number of table synchronization workers per subscription.
min_parallel_index_scan_size [0-715827882] 8kB Sets the minimum amount of index data for a parallel scan.
min_parallel_table_scan_size [0-715827882] 8kB Sets the minimum amount of table data for a parallel scan.
old_snapshot_threshold [-1-86400] min Time before a snapshot is too old to read pages changed after the snapshot was taken.
statement_timeout [0-2147483647] ms Sets the maximum allowed duration of any statement.
track_activity_query_size [100-102400] B Sets the size reserved for pg_stat_activity.query, in bytes.
vacuum_cleanup_index_scale_factor [0-10000000000] Number of tuple inserts prior to index cleanup as a fraction of reltuples.
vacuum_freeze_table_age [150000000-2000000000] Age at which VACUUM should scan whole table to freeze tuples.
wal_keep_segments [0-100000] Sets the number of WAL files held for standby servers.
wal_level [minimal,replica,logical] Set the level of information written to the WAL.
auto_explain.log_buffers [on|off] Log buffers usage.
auto_explain.log_format [text,xml,json,yaml] EXPLAIN format to be used for plan logging.
auto_explain.log_min_duration [-1-2147483647] ms Sets the minimum execution time above which plans will be logged.
auto_explain.log_nested_statements [on|off] Log nested statements.
auto_explain.log_timing [on|off] Collect timing data, not just row counts.
auto_explain.log_triggers [on|off] Include trigger statistics in plans.
auto_explain.log_verbose [on|off] Use EXPLAIN VERBOSE for plan logging.
auto_explain.sample_rate [0-1] Fraction of queries to process.
parallel_setup_cost [0-2147483647] Sets the planner's estimate of the cost of starting up worker processes for parallel query.
parallel_tuple_cost [0-2147483647] Sets the planner's estimate of the cost of passing each tuple (row) from worker to master backend.
work_mem [1024-1048576] kB Sets the maximum memory to be used for query workspaces.
idle_in_transaction_session_timeout [0-2147483647] ms Sets the maximum allowed duration of any idling transaction.