PostgreSQL settings
All configuration directives and values defined in pg_settings.
| Autovacuum | |||||
|---|---|---|---|---|---|
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| autovacuum | on | 0 | on | on | f |
| autovacuum_analyze_scale_factor | 0.1 | 0 | 0.1 | 0.1 | f |
| autovacuum_analyze_threshold | 50 | 0 | 50 | 50 | f |
| autovacuum_freeze_max_age | 200000000 | 0 | 200000000 | 200000000 | f |
| autovacuum_max_workers | 3 | 0 | 3 | 3 | f |
| autovacuum_multixact_freeze_max_age | 400000000 | 0 | 400000000 | 400000000 | f |
| autovacuum_naptime | 60 | s | 60 | 60 | f |
| autovacuum_vacuum_cost_delay | 2 | ms | 2 | 2 | f |
| autovacuum_vacuum_cost_limit | -1 | 0 | -1 | -1 | f |
| autovacuum_vacuum_insert_scale_factor | 0.2 | 0 | 0.2 | 0.2 | f |
| autovacuum_vacuum_insert_threshold | 1000 | 0 | 1000 | 1000 | f |
| autovacuum_vacuum_scale_factor | 0.2 | 0 | 0.2 | 0.2 | f |
| autovacuum_vacuum_threshold | 50 | 0 | 50 | 50 | f |
| Client Connection Defaults / Locale and Formatting | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| client_encoding | UTF8 | 0 | UTF8 | SQL_ASCII | f |
| DateStyle | ISO. DMY | 0 | ISO. DMY | ISO. MDY | f |
| default_text_search_config | pg_catalog.french | 0 | pg_catalog.french | pg_catalog.simple | f |
| extra_float_digits | 1 | 0 | 1 | 1 | f |
| icu_validation_level | warning | 0 | warning | warning | f |
| IntervalStyle | postgres | 0 | postgres | postgres | f |
| lc_messages | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | "" | f |
| lc_monetary | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C | f |
| lc_numeric | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C | f |
| lc_time | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C | f |
| TimeZone | Europe/Paris | 0 | Europe/Paris | GMT | f |
| timezone_abbreviations | Default | 0 | Default | f | |
| Client Connection Defaults / Other Defaults | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| dynamic_library_path | $libdir | 0 | $libdir | $libdir | f |
| gin_fuzzy_search_limit | 0 | 0 | f | ||
| Client Connection Defaults / Shared Library Preloading | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| jit_provider | llvmjit | 0 | llvmjit | llvmjit | f |
| local_preload_libraries | "" | 0 | "" | "" | f |
| session_preload_libraries | "" | 0 | "" | "" | f |
| shared_preload_libraries | credcheck | 0 | credcheck | "" | f |
| Client Connection Defaults / Statement Behavior | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| bytea_output | hex | 0 | hex | hex | f |
| check_function_bodies | on | 0 | on | on | f |
| client_min_messages | notice | 0 | notice | notice | f |
| createrole_self_grant | "" | 0 | "" | "" | f |
| default_table_access_method | heap | 0 | heap | heap | f |
| default_tablespace | "" | 0 | "" | "" | f |
| default_toast_compression | pglz | 0 | pglz | pglz | f |
| default_transaction_deferrable | off | 0 | off | off | f |
| default_transaction_isolation | read committed | 0 | read committed | read committed | f |
| default_transaction_read_only | off | 0 | off | off | f |
| gin_pending_list_limit | 4096 | kB | 4096 | 4096 | f |
| idle_in_transaction_session_timeout | 0 | ms | f | ||
| idle_session_timeout | 0 | ms | f | ||
| lock_timeout | 0 | ms | f | ||
| row_security | on | 0 | on | on | f |
| search_path | "" | 0 | """$user"". public" | """$user"". public" | f |
| session_replication_role | origin | 0 | origin | origin | f |
| statement_timeout | 0 | ms | f | ||
| temp_tablespaces | "" | 0 | "" | "" | f |
| transaction_deferrable | off | 0 | off | off | f |
| transaction_isolation | read committed | 0 | read committed | read committed | f |
| transaction_read_only | off | 0 | off | off | f |
| vacuum_failsafe_age | 1600000000 | 0 | 1600000000 | 1600000000 | f |
| vacuum_freeze_min_age | 50000000 | 0 | 50000000 | 50000000 | f |
| vacuum_freeze_table_age | 150000000 | 0 | 150000000 | 150000000 | f |
| vacuum_multixact_failsafe_age | 1600000000 | 0 | 1600000000 | 1600000000 | f |
| vacuum_multixact_freeze_min_age | 5000000 | 0 | 5000000 | 5000000 | f |
| vacuum_multixact_freeze_table_age | 150000000 | 0 | 150000000 | 150000000 | f |
| xmlbinary | base64 | 0 | base64 | base64 | f |
| xmloption | content | 0 | content | content | f |
| Connections and Authentication / Authentication | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| authentication_timeout | 60 | s | 60 | 60 | f |
| db_user_namespace | off | 0 | off | off | f |
| gss_accept_delegation | off | 0 | off | off | f |
| krb_caseins_users | off | 0 | off | off | f |
| krb_server_keyfile | "" | 0 | "" | "" | f |
| password_encryption | scram-sha-256 | 0 | scram-sha-256 | scram-sha-256 | f |
| scram_iterations | 4096 | 0 | 4096 | 4096 | f |
| Connections and Authentication / Connection Settings | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| bonjour | off | 0 | off | off | f |
| bonjour_name | "" | 0 | "" | "" | f |
| listen_addresses | localhost | 0 | localhost | localhost | f |
| max_connections | 100 | 0 | 100 | 100 | f |
| port | 5432 | 0 | 5432 | 5432 | f |
| reserved_connections | 0 | 0 | f | ||
| superuser_reserved_connections | 3 | 0 | 3 | 3 | f |
| unix_socket_directories | /tmp | 0 | /tmp | /tmp | f |
| unix_socket_group | "" | 0 | "" | "" | f |
| unix_socket_permissions | 0777 | 0 | 511 | 511 | f |
| Connections and Authentication / SSL | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| ssl | off | 0 | off | off | f |
| ssl_ca_file | "" | 0 | "" | "" | f |
| ssl_cert_file | server.crt | 0 | server.crt | server.crt | f |
| ssl_ciphers | none | 0 | none | none | f |
| ssl_crl_dir | "" | 0 | "" | "" | f |
| ssl_crl_file | "" | 0 | "" | "" | f |
| ssl_dh_params_file | "" | 0 | "" | "" | f |
| ssl_ecdh_curve | none | 0 | none | none | f |
| ssl_key_file | server.key | 0 | server.key | server.key | f |
| ssl_max_protocol_version | "" | 0 | "" | "" | f |
| ssl_min_protocol_version | TLSv1.2 | 0 | TLSv1.2 | TLSv1.2 | f |
| ssl_passphrase_command | "" | 0 | "" | "" | f |
| ssl_passphrase_command_supports_reload | off | 0 | off | off | f |
| ssl_prefer_server_ciphers | on | 0 | on | on | f |
| Connections and Authentication / TCP Settings | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| client_connection_check_interval | 0 | ms | f | ||
| tcp_keepalives_count | 9 | 0 | f | ||
| tcp_keepalives_idle | 7200 | s | f | ||
| tcp_keepalives_interval | 75 | s | f | ||
| tcp_user_timeout | 0 | ms | f | ||
| Customized Options | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| credcheck.auth_failure_cache_size | 1024 | 0 | 1024 | 1024 | f |
| credcheck.history_max_size | 65535 | 0 | 65535 | 65535 | f |
| credcheck.max_auth_failure | 2 | 0 | 2 | f | |
| credcheck.no_password_logging | on | 0 | on | on | f |
| credcheck.password_contain | "" | 0 | "" | "" | f |
| credcheck.password_contain_username | on | 0 | on | on | f |
| credcheck.password_ignore_case | off | 0 | off | off | f |
| credcheck.password_min_digit | 0 | 0 | f | ||
| credcheck.password_min_length | 1 | 0 | 1 | 1 | f |
| credcheck.password_min_lower | 0 | 0 | f | ||
| credcheck.password_min_repeat | 0 | 0 | f | ||
| credcheck.password_min_special | 0 | 0 | f | ||
| credcheck.password_min_upper | 0 | 0 | f | ||
| credcheck.password_not_contain | "" | 0 | "" | "" | f |
| credcheck.password_reuse_history | 3 | 0 | 3 | f | |
| credcheck.password_reuse_interval | 0 | 0 | f | ||
| credcheck.password_valid_max | 91 | 0 | 91 | f | |
| credcheck.password_valid_until | 41 | 0 | 41 | f | |
| credcheck.reset_superuser | off | 0 | off | off | f |
| credcheck.username_contain | "" | 0 | "" | "" | f |
| credcheck.username_contain_password | on | 0 | on | on | f |
| credcheck.username_ignore_case | off | 0 | off | off | f |
| credcheck.username_min_digit | 0 | 0 | f | ||
| credcheck.username_min_length | 1 | 0 | 1 | 1 | f |
| credcheck.username_min_lower | 0 | 0 | f | ||
| credcheck.username_min_repeat | 0 | 0 | f | ||
| credcheck.username_min_special | 0 | 0 | f | ||
| credcheck.username_min_upper | 0 | 0 | f | ||
| credcheck.username_not_contain | "" | 0 | "" | "" | f |
| Developer Options | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| allow_in_place_tablespaces | off | 0 | off | off | f |
| allow_system_table_mods | off | 0 | off | off | f |
| backtrace_functions | "" | 0 | "" | "" | f |
| debug_discard_caches | 0 | 0 | f | ||
| debug_io_direct | "" | 0 | "" | "" | f |
| debug_parallel_query | off | 0 | off | off | f |
| ignore_checksum_failure | off | 0 | off | off | f |
| ignore_invalid_pages | off | 0 | off | off | f |
| ignore_system_indexes | off | 0 | off | off | f |
| jit_debugging_support | off | 0 | off | off | f |
| jit_dump_bitcode | off | 0 | off | off | f |
| jit_expressions | on | 0 | on | on | f |
| jit_profiling_support | off | 0 | off | off | f |
| jit_tuple_deforming | on | 0 | on | on | f |
| logical_replication_mode | buffered | 0 | buffered | buffered | f |
| post_auth_delay | 0 | s | f | ||
| pre_auth_delay | 0 | s | f | ||
| remove_temp_files_after_crash | on | 0 | on | on | f |
| send_abort_for_crash | off | 0 | off | off | f |
| send_abort_for_kill | off | 0 | off | off | f |
| trace_notify | off | 0 | off | off | f |
| trace_recovery_messages | log | 0 | log | log | f |
| trace_sort | off | 0 | off | off | f |
| wal_consistency_checking | "" | 0 | "" | "" | f |
| zero_damaged_pages | off | 0 | off | off | f |
| Error Handling | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| data_sync_retry | off | 0 | off | off | f |
| exit_on_error | off | 0 | off | off | f |
| recovery_init_sync_method | fsync | 0 | fsync | fsync | f |
| restart_after_crash | on | 0 | on | on | f |
| File Locations | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| config_file | /usr/local/pgsql/data/postgresql.conf | 0 | /usr/local/pgsql/data/postgresql.conf | f | |
| data_directory | /usr/local/pgsql/data | 0 | /usr/local/pgsql/data | f | |
| external_pid_file | "" | 0 | f | ||
| hba_file | /usr/local/pgsql/data/pg_hba.conf | 0 | /usr/local/pgsql/data/pg_hba.conf | f | |
| ident_file | /usr/local/pgsql/data/pg_ident.conf | 0 | /usr/local/pgsql/data/pg_ident.conf | f | |
| Lock Management | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| deadlock_timeout | 1000 | ms | 1000 | 1000 | f |
| max_locks_per_transaction | 64 | 0 | 64 | 64 | f |
| max_pred_locks_per_page | 2 | 0 | 2 | 2 | f |
| max_pred_locks_per_relation | -2 | 0 | -2 | -2 | f |
| max_pred_locks_per_transaction | 64 | 0 | 64 | 64 | f |
| Preset Options | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| block_size | 8192 | 0 | 8192 | 8192 | f |
| data_checksums | off | 0 | off | off | f |
| data_directory_mode | 0700 | 0 | 448 | 448 | f |
| debug_assertions | on | 0 | on | on | f |
| in_hot_standby | off | 0 | off | off | f |
| integer_datetimes | on | 0 | on | on | f |
| lc_collate | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C | f |
| lc_ctype | fr_FR.UTF-8 | 0 | fr_FR.UTF-8 | C | f |
| max_function_args | 100 | 0 | 100 | 100 | f |
| max_identifier_length | 63 | 0 | 63 | 63 | f |
| max_index_keys | 32 | 0 | 32 | 32 | f |
| segment_size | 131072 | 8kB | 131072 | 131072 | f |
| server_encoding | UTF8 | 0 | UTF8 | SQL_ASCII | f |
| server_version | 16beta1 | 0 | 16beta1 | 16beta1 | f |
| server_version_num | 160000 | 0 | 160000 | 160000 | f |
| shared_memory_size | 154 | MB | 154 | f | |
| shared_memory_size_in_huge_pages | 77 | 0 | 77 | -1 | f |
| ssl_library | "" | 0 | "" | "" | f |
| wal_block_size | 8192 | 0 | 8192 | 8192 | f |
| wal_segment_size | 16777216 | B | 16777216 | 16777216 | f |
| Query Tuning / Genetic Query Optimizer | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| geqo | on | 0 | on | on | f |
| geqo_effort | 5 | 0 | 5 | 5 | f |
| geqo_generations | 0 | 0 | f | ||
| geqo_pool_size | 0 | 0 | f | ||
| geqo_seed | 0 | 0 | f | ||
| geqo_selection_bias | 2 | 0 | 2 | 2 | f |
| geqo_threshold | 12 | 0 | 12 | 12 | f |
| Query Tuning / Other Planner Options | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| constraint_exclusion | partition | 0 | partition | partition | f |
| cursor_tuple_fraction | 0.1 | 0 | 0.1 | 0.1 | f |
| default_statistics_target | 100 | 0 | 100 | 100 | f |
| from_collapse_limit | 8 | 0 | 8 | 8 | f |
| jit | on | 0 | on | on | f |
| join_collapse_limit | 8 | 0 | 8 | 8 | f |
| plan_cache_mode | auto | 0 | auto | auto | f |
| recursive_worktable_factor | 10 | 0 | 10 | 10 | f |
| Query Tuning / Planner Cost Constants | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| cpu_index_tuple_cost | 0.005 | 0 | 0.005 | 0.005 | f |
| cpu_operator_cost | 0.0025 | 0 | 0.0025 | 0.0025 | f |
| cpu_tuple_cost | 0.01 | 0 | 0.01 | 0.01 | f |
| effective_cache_size | 524288 | 8kB | 524288 | 524288 | f |
| jit_above_cost | 100000 | 0 | 100000 | 100000 | f |
| jit_inline_above_cost | 500000 | 0 | 500000 | 500000 | f |
| jit_optimize_above_cost | 500000 | 0 | 500000 | 500000 | f |
| min_parallel_index_scan_size | 64 | 8kB | 64 | 64 | f |
| min_parallel_table_scan_size | 1024 | 8kB | 1024 | 1024 | f |
| parallel_setup_cost | 1000 | 0 | 1000 | 1000 | f |
| parallel_tuple_cost | 0.1 | 0 | 0.1 | 0.1 | f |
| random_page_cost | 4 | 0 | 4 | 4 | f |
| seq_page_cost | 1 | 0 | 1 | 1 | f |
| Query Tuning / Planner Method Configuration | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| enable_async_append | on | 0 | on | on | f |
| enable_bitmapscan | on | 0 | on | on | f |
| enable_gathermerge | on | 0 | on | on | f |
| enable_hashagg | on | 0 | on | on | f |
| enable_hashjoin | on | 0 | on | on | f |
| enable_incremental_sort | on | 0 | on | on | f |
| enable_indexonlyscan | on | 0 | on | on | f |
| enable_indexscan | on | 0 | on | on | f |
| enable_material | on | 0 | on | on | f |
| enable_memoize | on | 0 | on | on | f |
| enable_mergejoin | on | 0 | on | on | f |
| enable_nestloop | on | 0 | on | on | f |
| enable_parallel_append | on | 0 | on | on | f |
| enable_parallel_hash | on | 0 | on | on | f |
| enable_partition_pruning | on | 0 | on | on | f |
| enable_partitionwise_aggregate | off | 0 | off | off | f |
| enable_partitionwise_join | off | 0 | off | off | f |
| enable_presorted_aggregate | on | 0 | on | on | f |
| enable_seqscan | on | 0 | on | on | f |
| enable_sort | on | 0 | on | on | f |
| enable_tidscan | on | 0 | on | on | f |
| Replication / Primary Server | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| synchronous_standby_names | "" | 0 | "" | "" | f |
| Replication / Sending Servers | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| max_replication_slots | 10 | 0 | 10 | 10 | f |
| max_slot_wal_keep_size | -1 | MB | -1 | -1 | f |
| max_wal_senders | 10 | 0 | 10 | 10 | f |
| track_commit_timestamp | off | 0 | off | off | f |
| wal_keep_size | 0 | MB | f | ||
| wal_sender_timeout | 60000 | ms | 60000 | 60000 | f |
| Replication / Standby Servers | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| hot_standby | on | 0 | on | on | f |
| hot_standby_feedback | off | 0 | off | off | f |
| max_standby_archive_delay | 30000 | ms | 30000 | 30000 | f |
| max_standby_streaming_delay | 30000 | ms | 30000 | 30000 | f |
| primary_conninfo | "" | 0 | "" | "" | f |
| primary_slot_name | "" | 0 | "" | "" | f |
| recovery_min_apply_delay | 0 | ms | f | ||
| wal_receiver_create_temp_slot | off | 0 | off | off | f |
| wal_receiver_status_interval | 10 | s | 10 | 10 | f |
| wal_receiver_timeout | 60000 | ms | 60000 | 60000 | f |
| wal_retrieve_retry_interval | 5000 | ms | 5000 | 5000 | f |
| Replication / Subscribers | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| max_logical_replication_workers | 4 | 0 | 4 | 4 | f |
| max_parallel_apply_workers_per_subscription | 2 | 0 | 2 | 2 | f |
| max_sync_workers_per_subscription | 2 | 0 | 2 | 2 | f |
| Reporting and Logging / Process Title | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| cluster_name | "" | 0 | "" | "" | f |
| update_process_title | on | 0 | on | on | f |
| Reporting and Logging / What to Log | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| application_name | pgcluu | 0 | psql | "" | f |
| debug_pretty_print | on | 0 | on | on | f |
| debug_print_parse | off | 0 | off | off | f |
| debug_print_plan | off | 0 | off | off | f |
| debug_print_rewritten | off | 0 | off | off | f |
| log_autovacuum_min_duration | 600000 | ms | 600000 | 600000 | f |
| log_checkpoints | on | 0 | on | on | f |
| log_connections | off | 0 | off | off | f |
| log_disconnections | off | 0 | off | off | f |
| log_duration | off | 0 | off | off | f |
| log_error_verbosity | default | 0 | default | default | f |
| log_hostname | off | 0 | off | off | f |
| log_line_prefix | %m [%p] | 0 | %m [%p] | %m [%p] | f |
| log_lock_waits | off | 0 | off | off | f |
| log_parameter_max_length | -1 | B | -1 | -1 | f |
| log_parameter_max_length_on_error | 0 | B | f | ||
| log_recovery_conflict_waits | off | 0 | off | off | f |
| log_replication_commands | off | 0 | off | off | f |
| log_statement | none | 0 | none | none | f |
| log_temp_files | -1 | kB | -1 | -1 | f |
| log_timezone | Europe/Paris | 0 | Europe/Paris | GMT | f |
| Reporting and Logging / When to Log | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| log_min_duration_sample | -1 | ms | -1 | -1 | f |
| log_min_duration_statement | -1 | ms | -1 | -1 | f |
| log_min_error_statement | error | 0 | error | error | f |
| log_min_messages | warning | 0 | warning | warning | f |
| log_startup_progress_interval | 10000 | ms | 10000 | 10000 | f |
| log_statement_sample_rate | 1 | 0 | 1 | 1 | f |
| log_transaction_sample_rate | 0 | 0 | f | ||
| Reporting and Logging / Where to Log | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| event_source | PostgreSQL | 0 | PostgreSQL | PostgreSQL | f |
| log_destination | stderr | 0 | stderr | stderr | f |
| log_directory | log | 0 | log | log | f |
| log_file_mode | 0600 | 0 | 384 | 384 | f |
| log_filename | postgresql-%Y-%m-%d_%H%M%S.log | 0 | postgresql-%Y-%m-%d_%H%M%S.log | postgresql-%Y-%m-%d_%H%M%S.log | f |
| log_rotation_age | 1440 | min | 1440 | 1440 | f |
| log_rotation_size | 10240 | kB | 10240 | 10240 | f |
| log_truncate_on_rotation | off | 0 | off | off | f |
| logging_collector | off | 0 | off | off | f |
| syslog_facility | local0 | 0 | local0 | local0 | f |
| syslog_ident | postgres | 0 | postgres | postgres | f |
| syslog_sequence_numbers | on | 0 | on | on | f |
| syslog_split_messages | on | 0 | on | on | f |
| Resource Usage / Asynchronous Behavior | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| backend_flush_after | 0 | 8kB | f | ||
| effective_io_concurrency | 1 | 0 | 1 | 1 | f |
| maintenance_io_concurrency | 10 | 0 | 10 | 10 | f |
| max_parallel_maintenance_workers | 2 | 0 | 2 | 2 | f |
| max_parallel_workers | 8 | 0 | 8 | 8 | f |
| max_parallel_workers_per_gather | 2 | 0 | 2 | 2 | f |
| max_worker_processes | 8 | 0 | 8 | 8 | f |
| old_snapshot_threshold | -1 | min | -1 | -1 | f |
| parallel_leader_participation | on | 0 | on | on | f |
| Resource Usage / Background Writer | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| bgwriter_delay | 200 | ms | 200 | 200 | f |
| bgwriter_flush_after | 64 | 8kB | 64 | 64 | f |
| bgwriter_lru_maxpages | 100 | 0 | 100 | 100 | f |
| bgwriter_lru_multiplier | 2 | 0 | 2 | 2 | f |
| Resource Usage / Cost-Based Vacuum Delay | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| vacuum_cost_delay | 0 | ms | f | ||
| vacuum_cost_limit | 200 | 0 | 200 | 200 | f |
| vacuum_cost_page_dirty | 20 | 0 | 20 | 20 | f |
| vacuum_cost_page_hit | 1 | 0 | 1 | 1 | f |
| vacuum_cost_page_miss | 2 | 0 | 2 | 2 | f |
| Resource Usage / Disk | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| temp_file_limit | -1 | kB | -1 | -1 | f |
| Resource Usage / Kernel Resources | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| max_files_per_process | 1000 | 0 | 1000 | 1000 | f |
| Resource Usage / Memory | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| autovacuum_work_mem | -1 | kB | -1 | -1 | f |
| dynamic_shared_memory_type | posix | 0 | posix | posix | f |
| hash_mem_multiplier | 2 | 0 | 2 | 2 | f |
| huge_page_size | 0 | kB | f | ||
| huge_pages | try | 0 | try | try | f |
| logical_decoding_work_mem | 65536 | kB | 65536 | 65536 | f |
| maintenance_work_mem | 65536 | kB | 65536 | 65536 | f |
| max_prepared_transactions | 0 | 0 | f | ||
| max_stack_depth | 2048 | kB | 2048 | 100 | f |
| min_dynamic_shared_memory | 0 | MB | f | ||
| shared_buffers | 16384 | 8kB | 16384 | 16384 | f |
| shared_memory_type | mmap | 0 | mmap | mmap | f |
| temp_buffers | 1024 | 8kB | 1024 | 1024 | f |
| vacuum_buffer_usage_limit | 256 | kB | 256 | 256 | f |
| work_mem | 4096 | kB | 4096 | 4096 | f |
| Statistics / Cumulative Query and Index Statistics | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| stats_fetch_consistency | cache | 0 | cache | cache | f |
| track_activities | on | 0 | on | on | f |
| track_activity_query_size | 1024 | B | 1024 | 1024 | f |
| track_counts | on | 0 | on | on | f |
| track_functions | none | 0 | none | none | f |
| track_io_timing | off | 0 | off | off | f |
| track_wal_io_timing | off | 0 | off | off | f |
| Statistics / Monitoring | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| compute_query_id | auto | 0 | auto | auto | f |
| log_executor_stats | off | 0 | off | off | f |
| log_parser_stats | off | 0 | off | off | f |
| log_planner_stats | off | 0 | off | off | f |
| log_statement_stats | off | 0 | off | off | f |
| Version and Platform Compatibility / Other Platforms and Clients | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| transform_null_equals | off | 0 | off | off | f |
| Version and Platform Compatibility / Previous PostgreSQL Versions | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| array_nulls | on | 0 | on | on | f |
| backslash_quote | safe_encoding | 0 | safe_encoding | safe_encoding | f |
| escape_string_warning | on | 0 | on | on | f |
| lo_compat_privileges | off | 0 | off | off | f |
| quote_all_identifiers | off | 0 | off | off | f |
| standard_conforming_strings | on | 0 | on | on | f |
| synchronize_seqscans | on | 0 | on | on | f |
| Write-Ahead Log / Archive Recovery | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| archive_cleanup_command | "" | 0 | "" | "" | f |
| recovery_end_command | "" | 0 | "" | "" | f |
| restore_command | "" | 0 | "" | "" | f |
| Write-Ahead Log / Archiving | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| archive_command | (disabled) | 0 | "" | "" | f |
| archive_library | "" | 0 | "" | "" | f |
| archive_mode | off | 0 | off | off | f |
| archive_timeout | 0 | s | f | ||
| Write-Ahead Log / Checkpoints | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| checkpoint_completion_target | 0.9 | 0 | 0.9 | 0.9 | f |
| checkpoint_flush_after | 32 | 8kB | 32 | 32 | f |
| checkpoint_timeout | 300 | s | 300 | 300 | f |
| checkpoint_warning | 30 | s | 30 | 30 | f |
| max_wal_size | 1024 | MB | 1024 | 1024 | f |
| min_wal_size | 80 | MB | 80 | 80 | f |
| Write-Ahead Log / Recovery | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| recovery_prefetch | try | 0 | try | try | f |
| wal_decode_buffer_size | 524288 | B | 524288 | 524288 | f |
| Write-Ahead Log / Recovery Target | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| recovery_target | "" | 0 | "" | "" | f |
| recovery_target_action | pause | 0 | pause | pause | f |
| recovery_target_inclusive | on | 0 | on | on | f |
| recovery_target_lsn | "" | 0 | "" | "" | f |
| recovery_target_name | "" | 0 | "" | "" | f |
| recovery_target_time | "" | 0 | "" | "" | f |
| recovery_target_timeline | latest | 0 | latest | latest | f |
| recovery_target_xid | "" | 0 | "" | "" | f |
| Write-Ahead Log / Settings | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| commit_delay | 0 | 0 | f | ||
| commit_siblings | 5 | 0 | 5 | 5 | f |
| fsync | on | 0 | on | on | f |
| full_page_writes | on | 0 | on | on | f |
| synchronous_commit | on | 0 | on | on | f |
| wal_buffers | 512 | 8kB | 512 | -1 | f |
| wal_compression | off | 0 | off | off | f |
| wal_init_zero | on | 0 | on | on | f |
| wal_level | replica | 0 | replica | replica | f |
| wal_log_hints | off | 0 | off | off | f |
| wal_recycle | on | 0 | on | on | f |
| wal_skip_threshold | 2048 | kB | 2048 | 2048 | f |
| wal_sync_method | fdatasync | 0 | fdatasync | fdatasync | f |
| wal_writer_delay | 200 | ms | 200 | 200 | f |
| wal_writer_flush_after | 128 | 8kB | 128 | 128 | f |