以下のコマンドをpgAdmin などで実行する。
show all;
以下のような結果が得られる。
name | setting | description |
---|---|---|
“aad_log_min_messages” | “warning” | “Sets the message levels that are logged by AAD components.” |
“aad_validate_oids_in_tenant” | “on” | “Sets whether to check specified AAD OIDs in the current tenant when creating an AAD user” |
“allow_redirection” | “XDBC setting.” | |
“allow_system_table_mods” | “off” | “Allows modifications of the structure of system tables.” |
“application_name” | “pgAdmin 4 - CONN:9261997” | “Sets the application name to be reported in statistics and logs.” |
“archive_azure_location” | “Sets the location where WAL gets archived in Azure” | |
“archive_command” | “c:\postgres\bin\xlogcopy\xlogcopy.exe archive blob “%f” “%p”” | “Sets the shell command that will be called to archive a WAL file.” |
“archive_mode” | “on” | “Allows archiving of WAL files using archive_command.” |
“archive_timeout” | “15min” | “Forces a switch to the next WAL file if a new file has not been started within N seconds.” |
“array_nulls” | “on” | “Enable input of NULL elements in arrays.” |
“authentication_timeout” | “30s” | “Sets the maximum allowed time to complete client authentication.” |
“autovacuum” | “on” | “Starts the autovacuum subprocess.” |
“autovacuum_analyze_scale_factor” | “0.05” | “Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.” |
“autovacuum_analyze_threshold” | “50” | “Minimum number of tuple inserts, updates, or deletes prior to analyze.” |
“autovacuum_freeze_max_age” | “200000000” | “Age at which to autovacuum a table to prevent transaction ID wraparound.” |
“autovacuum_max_workers” | “3” | “Sets the maximum number of simultaneously running autovacuum worker processes.” |
“autovacuum_multixact_freeze_max_age” | “400000000” | “Multixact age at which to autovacuum a table to prevent multixact wraparound.” |
“autovacuum_naptime” | “15s” | “Time to sleep between autovacuum runs.” |
“autovacuum_vacuum_cost_delay” | “20ms” | “Vacuum cost delay in milliseconds, for autovacuum.” |
“autovacuum_vacuum_cost_limit” | “-1” | “Vacuum cost amount available before napping, for autovacuum.” |
“autovacuum_vacuum_scale_factor” | “0.05” | “Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.” |
“autovacuum_vacuum_threshold” | “50” | “Minimum number of tuple updates or deletes prior to vacuum.” |
“autovacuum_work_mem” | “-1” | “Sets the maximum memory to be used by each autovacuum worker process.” |
“azure_debug_enabled” | “off” | “Enables Azure assertions during runtime.” |
“azure_td_enabled” | “off” | “Sets whether or not Azure Threat Detection is enabled.” |
“backend_flush_after” | “0” | “Number of pages after which previously performed writes are flushed to disk.” |
“backslash_quote” | “safe_encoding” | “Sets whether “'” is allowed in string literals.” |
“bgwriter_delay” | “20ms” | “Background writer sleep time between rounds.” |
“bgwriter_flush_after” | “512kB” | “Number of pages after which previously performed writes are flushed to disk.” |
“bgwriter_lru_maxpages” | “100” | “Background writer maximum number of LRU pages to flush per round.” |
“bgwriter_lru_multiplier” | “2” | “Multiple of the average buffer usage to free per round.” |
“block_size” | “8192” | “Shows the size of a disk block.” |
“bonjour” | “off” | “Enables advertising the server via Bonjour.” |
“bonjour_name” | “Sets the Bonjour service name.” | |
“bytea_output” | “escape” | “Sets the output format for bytea.” |
“check_function_bodies” | “on” | “Check function bodies during CREATE FUNCTION.” |
“checkpoint_completion_target” | “0.9” | “Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.” |
“checkpoint_flush_after” | “256kB” | “Number of pages after which previously performed writes are flushed to disk.” |
“checkpoint_timeout” | “5min” | “Sets the maximum time between automatic WAL checkpoints.” |
“checkpoint_warning” | “30s” | “Enables warnings if checkpoint segments are filled more frequently than this.” |
“client_encoding” | “UNICODE” | “Sets the client’s character set encoding.” |
“client_min_messages” | “notice” | “Sets the message levels that are sent to the client.” |
“cluster_name” | “Sets the name of the cluster, which is included in the process title.” | |
“commit_delay” | “0” | “Sets the delay in microseconds between transaction commit and flushing WAL to disk.” |
“commit_siblings” | “5” | “Sets the minimum concurrent open transactions before performing commit_delay.” |
“connection_ID” | “967d994d-452c-40af-831e-0ffa2f0848e9” | “Azure Connection ID. Can be used to diagnose connection issues in Azure” |
“connection_PeerIP” | “219.117.250.110” | “XDBC setting.” |
“connection_throttle.bucket_limit” | “2000” | “Max tokens per bucket” |
“connection_throttle.factor_bias” | “0.8” | “The factor bias for calculating number of tokens for an IP’s bucket” |
“connection_throttle.hash_entries_max” | “500” | “Max number of entries in the login failures hash table” |
“connection_throttle.reset_time” | “300” | “Time between resetting the login bucket” |
“connection_throttle.restore_factor” | “2” | “Factor to increase number of tokens by for IPs with low failure rate” |
“connection_throttle.update_time” | “20” | “Time between updating the login bucket” |
“connection_throttling” | “on” | “Enables temporary connection throttling per IP for too many login failures due to invalid password.” |
“connection_Vnet” | “off” | “XDBC setting.” |
“constraint_exclusion” | “partition” | “Enables the planner to use constraints to optimize queries.” |
“cpu_index_tuple_cost” | “0.005” | “Sets the planner’s estimate of the cost of processing each index entry during an index scan.” |
“cpu_operator_cost” | “0.0025” | “Sets the planner’s estimate of the cost of processing each operator or function call.” |
“cpu_tuple_cost” | “0.01” | “Sets the planner’s estimate of the cost of processing each tuple (row).” |
“cursor_tuple_fraction” | “0.1” | “Sets the planner’s estimate of the fraction of a cursor’s rows that will be retrieved.” |
“data_checksums” | “on” | “Shows whether data checksums are turned on for this cluster.” |
“data_directory_mode” | “0700” | “Mode of the data directory.” |
“data_sync_retry” | “on” | “Whether to continue running after a failure to sync data files.” |
“DateStyle” | “ISO, MDY” | “Sets the display format for date and time values.” |
“db_user_namespace” | “off” | “Enables per-database user names.” |
“deadlock_timeout” | “1s” | “Sets the time to wait on a lock before checking for deadlock.” |
“debug_assertions” | “off” | “Shows whether the running server has assertion checks enabled.” |
“debug_pretty_print” | “on” | “Indents parse and plan tree displays.” |
“debug_print_parse” | “off” | “Logs each query’s parse tree.” |
“debug_print_plan” | “off” | “Logs each query’s execution plan.” |
“debug_print_rewritten” | “off” | “Logs each query’s rewritten parse tree.” |
“default_statistics_target” | “130” | “Sets the default statistics target.” |
“default_tablespace” | “Sets the default tablespace to create tables and indexes in.” | |
“default_text_search_config” | “pg_catalog.english” | “Sets default text search configuration.” |
“default_transaction_deferrable” | “off” | “Sets the default deferrable status of new transactions.” |
“default_transaction_isolation” | “read committed” | “Sets the transaction isolation level of each new transaction.” |
“default_transaction_read_only” | “off” | “Sets the default read-only status of new transactions.” |
“default_with_oids” | “off” | “Create new tables with OIDs by default.” |
“dynamic_shared_memory_type” | “windows” | “Selects the dynamic shared memory implementation used.” |
“effective_cache_size” | “5GB” | “Sets the planner’s assumption about the total size of the data caches.” |
“effective_io_concurrency” | “0” | “Number of simultaneous requests that can be handled efficiently by the disk subsystem.” |
“enable_bitmapscan” | “on” | “Enables the planner’s use of bitmap-scan plans.” |
“enable_gathermerge” | “on” | “Enables the planner’s use of gather merge plans.” |
“enable_hashagg” | “on” | “Enables the planner’s use of hashed aggregation plans.” |
“enable_hashjoin” | “on” | “Enables the planner’s use of hash join plans.” |
“enable_indexonlyscan” | “on” | “Enables the planner’s use of index-only-scan plans.” |
“enable_indexscan” | “on” | “Enables the planner’s use of index-scan plans.” |
“enable_material” | “on” | “Enables the planner’s use of materialization.” |
“enable_mergejoin” | “on” | “Enables the planner’s use of merge join plans.” |
“enable_nestloop” | “on” | “Enables the planner’s use of nested-loop join plans.” |
“enable_parallel_append” | “on” | “Enables the planner’s use of parallel append plans.” |
“enable_parallel_hash” | “on” | “Enables the planner’s use of parallel hash plans.” |
“enable_partition_pruning” | “on” | “Enable plan-time and run-time partition pruning.” |
“enable_partitionwise_aggregate” | “off” | “Enables partitionwise aggregation and grouping.” |
“enable_partitionwise_join” | “off” | “Enables partitionwise join.” |
“enable_seqscan” | “on” | “Enables the planner’s use of sequential-scan plans.” |
“enable_sort” | “on” | “Enables the planner’s use of explicit sort steps.” |
“enable_tidscan” | “on” | “Enables the planner’s use of TID scan plans.” |
“escape_string_warning” | “on” | “Warn about backslash escapes in ordinary string literals.” |
“event_source” | “PostgreSQL” | “Sets the application name used to identify PostgreSQL messages in the event log.” |
“exit_on_error” | “off” | “Terminate session on any error.” |
“extra_float_digits” | “0” | “Sets the number of digits displayed for floating-point values.” |
“force_parallel_mode” | “off” | “Forces use of parallel query facilities.” |
“from_collapse_limit” | “8” | “Sets the FROM-list size beyond which subqueries are not collapsed.” |
“fsync” | “on” | “Forces synchronization of updates to disk.” |
“full_page_writes” | “off” | “Writes full pages to WAL when first modified after a checkpoint.” |
“geqo” | “on” | “Enables genetic query optimization.” |
“geqo_effort” | “5” | “GEQO: effort is used to set the default for other GEQO parameters.” |
“geqo_generations” | “0” | “GEQO: number of iterations of the algorithm.” |
“geqo_pool_size” | “0” | “GEQO: number of individuals in the population.” |
“geqo_seed” | “0” | “GEQO: seed for random path selection.” |
“geqo_selection_bias” | “2” | “GEQO: selective pressure within the population.” |
“geqo_threshold” | “12” | “Sets the threshold of FROM items beyond which GEQO is used.” |
“gin_fuzzy_search_limit” | “0” | “Sets the maximum allowed result for exact search by GIN.” |
“gin_pending_list_limit” | “4MB” | “Sets the maximum size of the pending list for GIN index.” |
“hba_cache_force_update” | “off” | “When set to on forces PG to check whether the pg_hba.conf cache needs reloading” |
“hot_standby” | “on” | “Allows connections and queries during recovery.” |
“hot_standby_feedback” | “on” | “Allows feedback from a hot standby to the primary that will avoid query conflicts.” |
“huge_pages” | “try” | “Use of huge pages on Linux or Windows.” |
“idle_in_transaction_session_timeout” | “0” | “Sets the maximum allowed duration of any idling transaction.” |
“ignore_checksum_failure” | “off” | “Continues processing after a checksum failure.” |
“ignore_system_indexes” | “off” | “Disables reading from system indexes.” |
“integer_datetimes” | “on” | “Datetimes are integer based.” |
“IntervalStyle” | “postgres” | “Sets the display format for interval values.” |
“iperf.databases_to_track” | “none” | “Specifies a comma-separated list of database names to be tracked by intelligent performance feature. “none” (default) tracks none, “all” tracks all of the user databases within published limits.” |
“jit” | “off” | “Allow JIT compilation.” |
“jit_above_cost” | “100000” | “Perform JIT compilation if query is more expensive.” |
“jit_debugging_support” | “off” | “Register JIT compiled function with debugger.” |
“jit_dump_bitcode” | “off” | “Write out LLVM bitcode to facilitate JIT debugging.” |
“jit_expressions” | “on” | “Allow JIT compilation of expressions.” |
“jit_inline_above_cost” | “500000” | “Perform JIT inlining if query is more expensive.” |
“jit_optimize_above_cost” | “500000” | “Optimize JITed functions if query is more expensive.” |
“jit_profiling_support” | “off” | “Register JIT compiled function with perf profiler.” |
“jit_tuple_deforming” | “on” | “Allow JIT compilation of tuple deforming.” |
“join_collapse_limit” | “8” | “Sets the FROM-list size beyond which JOIN constructs are not flattened.” |
“krb_caseins_users” | “off” | “Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.” |
“lc_collate” | “English_United States.1252” | “Shows the collation order locale.” |
“lc_ctype” | “English_United States.1252” | “Shows the character classification and case conversion locale.” |
“lc_messages” | “English_United States.1252” | “Sets the language in which messages are displayed.” |
“lc_monetary” | “English_United States.1252” | “Sets the locale for formatting monetary amounts.” |
“lc_numeric” | “English_United States.1252” | “Sets the locale for formatting numbers.” |
“lc_time” | “English_United States.1252” | “Sets the locale for formatting date and time values.” |
“listen_addresses” | “*” | “Sets the host name or IP address(es) to listen to.” |
“lo_compat_privileges” | “off” | “Enables backward compatibility mode for privilege checks on large objects.” |
“local_preload_libraries” | “Lists unprivileged shared libraries to preload into each backend.” | |
“lock_timeout” | “0” | “Sets the maximum allowed duration of any wait for a lock.” |
“log_autovacuum_min_duration” | “-1” | “Sets the minimum execution time above which autovacuum actions will be logged.” |
“log_checkpoints” | “on” | “Logs each checkpoint.” |
“log_connections” | “on” | “Logs each successful connection.” |
“log_destination” | “stderr” | “Sets the destination for server log output.” |
“log_disconnections” | “off” | “Logs end of a session, including duration.” |
“log_duration” | “off” | “Logs the duration of each completed SQL statement.” |
“log_error_verbosity” | “default” | “Sets the verbosity of logged messages.” |
“log_executor_stats” | “off” | “Writes executor performance statistics to the server log.” |
“log_file_mode” | “0640” | “Sets the file permissions for log files.” |
“log_hostname” | “off” | “Logs the host name in the connection logs.” |
“log_invalid_encoding_extended” | “off” | “Enables logging an error status when an invalid encoding error is thrown.” |
“log_line_prefix” | “%t-%c-“ | “Controls information prefixed to each log line.” |
“log_lock_waits” | “off” | “Logs long lock waits.” |
“log_min_duration_statement” | “-1” | “Sets the minimum execution time above which statements will be logged.” |
“log_min_error_statement” | “error” | “Causes all statements generating error at or above this level to be logged.” |
“log_min_messages” | “warning” | “Sets the message levels that are logged.” |
“log_min_messages_internal” | “info” | “Sets the message levels that are logged into internal logs.” |
“log_parser_stats” | “off” | “Writes parser performance statistics to the server log.” |
“log_planner_stats” | “off” | “Writes planner performance statistics to the server log.” |
“log_replication_commands” | “off” | “Logs each replication command.” |
“log_rotation_age” | “1h” | “Automatic log file rotation will occur after N minutes.” |
“log_rotation_size” | “100MB” | “Automatic log file rotation will occur after N kilobytes.” |
“log_statement” | “none” | “Sets the type of statements logged.” |
“log_statement_stats” | “off” | “Writes cumulative performance statistics to the server log.” |
“log_temp_files” | “-1” | “Log the use of temporary files larger than this number of kilobytes.” |
“log_timezone” | “UTC” | “Sets the time zone to use in log messages.” |
“log_truncate_on_rotation” | “off” | “Truncate existing log files of same name during log rotation.” |
“logging_collector” | “on” | “Start a subprocess to capture stderr output and/or csvlogs into log files.” |
“maintenance_work_mem” | “128MB” | “Sets the maximum memory to be used for maintenance operations.” |
“max_connections” | “150” | “Sets the maximum number of concurrent connections.” |
“max_files_per_process” | “1000” | “Sets the maximum number of simultaneously open files for each server process.” |
“max_function_args” | “100” | “Shows the maximum number of function arguments.” |
“max_identifier_length” | “63” | “Shows the maximum identifier length.” |
“max_index_keys” | “32” | “Shows the maximum number of index keys.” |
“max_locks_per_transaction” | “64” | “Sets the maximum number of locks per transaction.” |
“max_logical_replication_workers” | “4” | “Maximum number of logical replication worker processes.” |
“max_parallel_maintenance_workers” | “2” | “Sets the maximum number of parallel processes per maintenance operation.” |
“max_parallel_workers” | “8” | “Sets the maximum number of parallel workers that can be active at one time.” |
“max_parallel_workers_per_gather” | “2” | “Sets the maximum number of parallel processes per executor node.” |
“max_pred_locks_per_page” | “2” | “Sets the maximum number of predicate-locked tuples per page.” |
“max_pred_locks_per_relation” | “-2” | “Sets the maximum number of predicate-locked pages and tuples per relation.” |
“max_pred_locks_per_transaction” | “64” | “Sets the maximum number of predicate locks per transaction.” |
“max_prepared_transactions” | “0” | “Sets the maximum number of simultaneously prepared transactions.” |
“max_replication_slots” | “10” | “Sets the maximum number of simultaneously defined replication slots.” |
“max_stack_depth” | “2MB” | “Sets the maximum stack depth, in kilobytes.” |
“max_standby_archive_delay” | “30s” | “Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.” |
“max_standby_streaming_delay” | “30s” | “Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.” |
“max_sync_workers_per_subscription” | “2” | “Maximum number of table synchronization workers per subscription.” |
“max_wal_senders” | “10” | “Sets the maximum number of simultaneously running WAL sender processes.” |
“max_wal_size” | “2GB” | “Sets the WAL size that triggers a checkpoint.” |
“max_worker_processes” | “8” | “Maximum number of concurrent worker processes.” |
“min_parallel_index_scan_size” | “512kB” | “Sets the minimum amount of index data for a parallel scan.” |
“min_parallel_table_scan_size” | “8MB” | “Sets the minimum amount of table data for a parallel scan.” |
“min_wal_size” | “512MB” | “Sets the minimum size to shrink the WAL to.” |
“old_snapshot_threshold” | “-1” | “Time before a snapshot is too old to read pages changed after the snapshot was taken.” |
“operator_precedence_warning” | “off” | “Emit a warning for constructs that changed meaning since PostgreSQL 9.4.” |
“parallel_leader_participation” | “on” | “Controls whether Gather and Gather Merge also run subplans.” |
“parallel_setup_cost” | “1000” | “Sets the planner’s estimate of the cost of starting up worker processes for parallel query.” |
“parallel_tuple_cost” | “0.1” | “Sets the planner’s estimate of the cost of passing each tuple (row) from worker to master backend.” |
“password_encryption” | “md5” | “Encrypt passwords.” |
“pg_qs.host_database” | “azure_sys” | “Specifies host database name for qs. Need to restart the server to make change take effect.” |
“pg_qs.interval_length_minutes” | “15” | “Sets the aggregration window in minutes. Need to restart the server to make change take effect.” |
“pg_qs.max_queries” | “500” | “Sets the maximum number of unique queries tracked by pg_qs during each aggregation window. Need to restart the server to make change take effect.” |
“pg_qs.max_query_text_length” | “6000” | “Sets the maximum query text length that will be saved; longer queries will be truncated. Need to reload the config to make change take effect.” |
“pg_qs.query_capture_mode” | “top” | “Selects which statements are tracked by pg_qs. Need to reload the config to make change take effect.” |
“pg_qs.replace_parameter_placeholders” | “off” | “Selects whether parameter values from parameterized queries are substituted into queries.” |
“pg_qs.retention_period_in_days” | “7” | “Sets the retention period window in days for pg_qs - after this time data will be deleted. Need to restart the server to make change take effect.” |
“pg_qs.track_utility” | “on” | “Selects whether utility commands are tracked by pg_qs. Need to reload the config to make change take effect.” |
“pg_stat_statements.max” | “5000” | “Sets the maximum number of statements tracked by pg_stat_statements.” |
“pg_stat_statements.save” | “on” | “Save pg_stat_statements statistics across server shutdowns.” |
“pg_stat_statements.track” | “none” | “Selects which statements are tracked by pg_stat_statements.” |
“pg_stat_statements.track_utility” | “on” | “Selects whether utility commands are tracked by pg_stat_statements.” |
“pgms_wait_sampling.history_period” | “100” | “Sets the the frequency, in milliseconds, at which wait events are sampled.” |
“pgms_wait_sampling.query_capture_mode” | “none” | “Selects types of wait events are tracked by this extension. Need to reload the config to make change take effect.” |
“pgstat_udp_port” | “20335” | “Sets the UDP port for statistics collector.” |
“port” | “20335” | “Sets the TCP port the server listens on.” |
“post_auth_delay” | “0” | “Waits N seconds on connection startup after authentication.” |
“pre_auth_delay” | “0” | “Waits N seconds on connection startup before authentication.” |
“quote_all_identifiers” | “off” | “When generating SQL fragments, quote all identifiers.” |
“random_page_cost” | “1” | “Sets the planner’s estimate of the cost of a nonsequentially fetched disk page.” |
“restart_after_crash” | “on” | “Reinitialize server after backend crash.” |
“row_security” | “on” | “Enable row security.” |
“search_path” | ”“$user”, public” | “Sets the schema search order for names that are not schema-qualified.” |
“segment_size” | “1GB” | “Shows the number of pages per disk file.” |
“seq_page_cost” | “1” | “Sets the planner’s estimate of the cost of a sequentially fetched disk page.” |
“server_encoding” | “UTF8” | “Sets the server (database) character set encoding.” |
“server_version” | “11.6” | “Shows the server version.” |
“server_version_num” | “110006” | “Shows the server version as an integer.” |
“session_replication_role” | “origin” | “Sets the session’s behavior for triggers and rewrite rules.” |
“shared_buffers” | “2GB” | “Sets the number of shared memory buffers used by the server.” |
“ssl” | “on” | “Enables SSL connections.” |
“ssl_ca_file” | “root.crt” | “Location of the SSL certificate authority file.” |
“ssl_cert_file” | “server.crt” | “Location of the SSL server certificate file.” |
“ssl_crl_file” | “Location of the SSL certificate revocation list file.” | |
“ssl_key_file” | “server.key” | “Location of the SSL server private key file.” |
“ssl_passphrase_command” | “Command to obtain passphrases for SSL.” | |
“ssl_passphrase_command_supports_reload” | “off” | “Also use ssl_passphrase_command during server reload.” |
“ssl_prefer_server_ciphers” | “on” | “Give priority to server ciphersuite order.” |
“standard_conforming_strings” | “on” | “Causes ‘…’ strings to treat backslashes literally.” |
“statement_timeout” | “0” | “Sets the maximum allowed duration of any statement.” |
“superuser_reserved_connections” | “5” | “Sets the number of connection slots reserved for superusers.” |
“synchronize_seqscans” | “on” | “Enable synchronized sequential scans.” |
“synchronous_commit” | “on” | “Sets the current transaction’s synchronization level.” |
“synchronous_standby_names” | “Number of synchronous standbys and list of names of potential synchronous ones.” | |
“syslog_facility” | “none” | “Sets the syslog “facility” to be used when syslog enabled.” |
“syslog_ident” | “postgres” | “Sets the program name used to identify PostgreSQL messages in syslog.” |
“syslog_sequence_numbers” | “on” | “Add sequence number to syslog messages to avoid duplicate suppression.” |
“syslog_split_messages” | “on” | “Split messages sent to syslog by lines and to fit into 1024 bytes.” |
“tcp_keepalives_count” | “0” | “Maximum number of TCP keepalive retransmits.” |
“tcp_keepalives_idle” | “-1” | “Time between issuing TCP keepalives.” |
“tcp_keepalives_interval” | “-1” | “Time between TCP keepalive retransmits.” |
“temp_buffers” | “8MB” | “Sets the maximum number of temporary buffers used by each session.” |
“temp_file_limit” | “-1” | “Limits the total size of all temporary files used by each process.” |
“temp_tablespaces” | “Sets the tablespace(s) to use for temporary tables and sort files.” | |
“TimeZone” | “UTC” | “Sets the time zone for displaying and interpreting time stamps.” |
“timezone_abbreviations” | “Default” | “Selects a file of time zone abbreviations.” |
“trace_notify” | “off” | “Generates debugging output for LISTEN and NOTIFY.” |
“trace_recovery_messages” | “log” | “Enables logging of recovery-related debugging information.” |
“trace_sort” | “off” | “Emit information about resource usage in sorting.” |
“track_activities” | “on” | “Collects information about executing commands.” |
“track_activity_query_size” | “1kB” | “Sets the size reserved for pg_stat_activity.query, in bytes.” |
“track_commit_timestamp” | “off” | “Collects transaction commit time.” |
“track_counts” | “on” | “Collects statistics on database activity.” |
“track_file_io_timing” | “on” | “Collects timing statistics for file I/O activity.” |
“track_functions” | “none” | “Collects function-level statistics on database activity.” |
“track_io_timing” | “on” | “Collects timing statistics for database I/O activity.” |
“transaction_deferrable” | “off” | “Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.” |
“transaction_isolation” | “read committed” | “Sets the current transaction’s isolation level.” |
“transaction_read_only” | “off” | “Sets the current transaction’s read-only status.” |
“transform_null_equals” | “off” | “Treats “expr=NULL” as “expr IS NULL”.” |
“unix_socket_group” | “Sets the owning group of the Unix-domain socket.” | |
“unix_socket_permissions” | “0777” | “Sets the access permissions of the Unix-domain socket.” |
“update_process_title” | “off” | “Updates the process title to show the active SQL command.” |
“vacuum_cleanup_index_scale_factor” | “0.1” | “Number of tuple inserts prior to index cleanup as a fraction of reltuples.” |
“vacuum_cost_delay” | “0” | “Vacuum cost delay in milliseconds.” |
“vacuum_cost_limit” | “200” | “Vacuum cost amount available before napping.” |
“vacuum_cost_page_dirty” | “20” | “Vacuum cost for a page dirtied by vacuum.” |
“vacuum_cost_page_hit” | “1” | “Vacuum cost for a page found in the buffer cache.” |
“vacuum_cost_page_miss” | “10” | “Vacuum cost for a page not found in the buffer cache.” |
“vacuum_defer_cleanup_age” | “0” | “Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.” |
“vacuum_freeze_min_age” | “50000000” | “Minimum age at which VACUUM should freeze a table row.” |
“vacuum_freeze_table_age” | “150000000” | “Age at which VACUUM should scan whole table to freeze tuples.” |
“vacuum_multixact_freeze_min_age” | “5000000” | “Minimum age at which VACUUM should freeze a MultiXactId in a table row.” |
“vacuum_multixact_freeze_table_age” | “150000000” | “Multixact age at which VACUUM should scan whole table to freeze tuples.” |
“wal_block_size” | “8192” | “Shows the block size in the write ahead log.” |
“wal_buffers” | “64MB” | “Sets the number of disk-page buffers in shared memory for WAL.” |
“wal_compression” | “off” | “Compresses full-page writes written in WAL file.” |
“wal_consistency_checking” | “Sets the WAL resource managers for which WAL consistency checks are done.” | |
“wal_keep_segments” | “25” | “Sets the number of WAL files held for standby servers.” |
“wal_level” | “replica” | “Set the level of information written to the WAL.” |
“wal_log_hints” | “off” | “Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modifications.” |
“wal_receiver_status_interval” | “10s” | “Sets the maximum interval between WAL receiver status reports to the primary.” |
“wal_receiver_timeout” | “1min” | “Sets the maximum wait time to receive data from the primary.” |
“wal_retrieve_retry_interval” | “5s” | “Sets the time to wait before retrying to retrieve WAL after a failed attempt.” |
“wal_segment_size” | “16MB” | “Shows the size of write ahead log segments.” |
“wal_sender_timeout” | “1min” | “Sets the maximum time to wait for WAL replication.” |
“wal_sync_method” | “open_datasync” | “Selects the method used for forcing WAL updates to disk.” |
“wal_writer_delay” | “200ms” | “Time between WAL flushes performed in the WAL writer.” |
“wal_writer_flush_after” | “1MB” | “Amount of WAL written out by WAL writer that triggers a flush.” |
“work_mem” | “26214kB” | “Sets the maximum memory to be used for query workspaces.” |
“xmlbinary” | “base64” | “Sets how binary values are to be encoded in XML.” |
“xmloption” | “content” | “Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.” |
“zero_damaged_pages” | “off” | “Continues processing past damaged page headers.” |