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 | 20 | ms | 20 | 20 | f |
| autovacuum_vacuum_cost_limit | -1 | 0 | -1 | -1 | 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. MDY | 0 | ISO. MDY | ISO. MDY | f |
| default_text_search_config | pg_catalog.english | 0 | pg_catalog.english | pg_catalog.simple | f |
| extra_float_digits | 0 | 0 | f | ||
| IntervalStyle | postgres | 0 | postgres | postgres | f |
| lc_collate | en_US.utf-8 | 0 | en_US.utf-8 | C | f |
| lc_ctype | en_US.utf-8 | 0 | en_US.utf-8 | C | f |
| lc_messages | en_US.utf-8 | 0 | en_US.utf-8 | "" | f |
| lc_monetary | en_US.utf-8 | 0 | en_US.utf-8 | C | f |
| lc_numeric | en_US.utf-8 | 0 | en_US.utf-8 | C | f |
| lc_time | en_US.utf-8 | 0 | en_US.utf-8 | C | f |
| server_encoding | UTF8 | 0 | UTF8 | SQL_ASCII | f |
| TimeZone | America/Mexico_City | 0 | America/Mexico_City | 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 | ||
| tcp_keepalives_count | 9 | 0 | f | ||
| tcp_keepalives_idle | 7200 | s | f | ||
| tcp_keepalives_interval | 75 | s | f | ||
| Client Connection Defaults / Shared Library Preloading | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| local_preload_libraries | "" | 0 | "" | "" | f |
| session_preload_libraries | "" | 0 | "" | "" | f |
| shared_preload_libraries | "" | 0 | "" | "" | 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 |
| default_tablespace | "" | 0 | "" | "" | 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 |
| lock_timeout | 0 | ms | 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 | default | default | f |
| transaction_read_only | off | 0 | off | off | f |
| vacuum_freeze_min_age | 50000000 | 0 | 50000000 | 50000000 | f |
| vacuum_freeze_table_age | 150000000 | 0 | 150000000 | 150000000 | 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 / 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 |
| superuser_reserved_connections | 3 | 0 | 3 | 3 | f |
| unix_socket_directories | /var/run/postgresql | 0 | /var/run/postgresql | /var/run/postgresql | f |
| unix_socket_group | "" | 0 | "" | "" | f |
| unix_socket_permissions | 0777 | 0 | 511 | 511 | f |
| Connections and Authentication / Security and 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 |
| krb_caseins_users | off | 0 | off | off | f |
| krb_server_keyfile | FILE:/etc/postgresql-common/krb5.keytab | 0 | FILE:/etc/postgresql-common/krb5.keytab | FILE:/etc/postgresql-common/krb5.keytab | f |
| password_encryption | on | 0 | on | on | f |
| row_security | on | 0 | on | on | f |
| ssl | on | 0 | on | off | f |
| ssl_ca_file | "" | 0 | "" | "" | f |
| ssl_cert_file | /etc/ssl/certs/ssl-cert-snakeoil.pem | 0 | /etc/ssl/certs/ssl-cert-snakeoil.pem | server.crt | f |
| ssl_ciphers | HIGH:MEDIUM:+3DES:!aNULL | 0 | HIGH:MEDIUM:+3DES:!aNULL | HIGH:MEDIUM:+3DES:!aNULL | f |
| ssl_crl_file | "" | 0 | "" | "" | f |
| ssl_ecdh_curve | prime256v1 | 0 | prime256v1 | prime256v1 | f |
| ssl_key_file | /etc/ssl/private/ssl-cert-snakeoil.key | 0 | /etc/ssl/private/ssl-cert-snakeoil.key | server.key | f |
| ssl_prefer_server_ciphers | on | 0 | on | on | f |
| Developer Options | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| allow_system_table_mods | off | 0 | off | off | f |
| ignore_checksum_failure | off | 0 | off | off | f |
| ignore_system_indexes | off | 0 | off | off | f |
| post_auth_delay | 0 | s | f | ||
| pre_auth_delay | 0 | s | f | ||
| trace_notify | off | 0 | off | off | f |
| trace_recovery_messages | log | 0 | log | log | f |
| trace_sort | off | 0 | off | off | 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 |
| restart_after_crash | on | 0 | on | on | f |
| File Locations | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| config_file | /etc/postgresql/9.5/main/postgresql.conf | 0 | /etc/postgresql/9.5/main/postgresql.conf | f | |
| data_directory | /var/lib/postgresql/9.5/main | 0 | /var/lib/postgresql/9.5/main | f | |
| external_pid_file | /var/run/postgresql/9.5-main.pid | 0 | /var/run/postgresql/9.5-main.pid | f | |
| hba_file | /etc/postgresql/9.5/main/pg_hba.conf | 0 | /etc/postgresql/9.5/main/pg_hba.conf | f | |
| ident_file | /etc/postgresql/9.5/main/pg_ident.conf | 0 | /etc/postgresql/9.5/main/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_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 |
| debug_assertions | off | 0 | off | off | f |
| integer_datetimes | on | 0 | on | on | 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_version | 9.5.25 | 0 | 9.5.25 | 9.5.25 | f |
| server_version_num | 90525 | 0 | 90525 | 90525 | f |
| wal_block_size | 8192 | 0 | 8192 | 8192 | f |
| wal_segment_size | 2048 | 8kB | 2048 | 2048 | f |
| Process Title | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| cluster_name | "" | 0 | "" | "" | f |
| update_process_title | on | 0 | on | on | 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 |
| join_collapse_limit | 8 | 0 | 8 | 8 | 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 |
| 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_bitmapscan | on | 0 | on | on | f |
| enable_hashagg | on | 0 | on | on | f |
| enable_hashjoin | 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_mergejoin | on | 0 | on | on | f |
| enable_nestloop | 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 | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| track_commit_timestamp | off | 0 | off | off | f |
| Replication / Master Server | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| synchronous_standby_names | "" | 0 | "" | "" | f |
| vacuum_defer_cleanup_age | 0 | 0 | f | ||
| Replication / Sending Servers | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| max_replication_slots | 0 | 0 | f | ||
| max_wal_senders | 0 | 0 | f | ||
| wal_keep_segments | 0 | 0 | f | ||
| wal_sender_timeout | 60000 | ms | 60000 | 60000 | f |
| Replication / Standby Servers | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| hot_standby | off | 0 | off | off | 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 |
| 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 |
| 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 | -1 | ms | -1 | -1 | f |
| log_checkpoints | off | 0 | off | off | 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 | %t [%p-%l] %q%u@%d | 0 | %t [%p-%l] %q%u@%d | "" | f |
| log_lock_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 | America/Mexico_City | 0 | America/Mexico_City | GMT | f |
| Reporting and Logging / When to Log | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| client_min_messages | notice | 0 | notice | notice | 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 |
| 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 | pg_log | 0 | pg_log | pg_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 |
| Resource Usage / Asynchronous Behavior | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| effective_io_concurrency | 1 | 0 | 1 | 1 | f |
| max_worker_processes | 8 | 0 | 8 | 8 | f |
| Resource Usage / Background Writer | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| bgwriter_delay | 200 | ms | 200 | 200 | 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 | 10 | 0 | 10 | 10 | 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 |
| huge_pages | try | 0 | try | try | f |
| maintenance_work_mem | 65536 | kB | 65536 | 65536 | f |
| max_prepared_transactions | 0 | 0 | f | ||
| max_stack_depth | 2048 | kB | 2048 | 100 | f |
| shared_buffers | 16384 | 8kB | 16384 | 1024 | f |
| temp_buffers | 1024 | 8kB | 1024 | 1024 | f |
| track_activity_query_size | 1024 | 0 | 1024 | 1024 | f |
| work_mem | 4096 | kB | 4096 | 4096 | f |
| Statistics / Monitoring | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| 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 |
| Statistics / Query and Index Statistics Collector | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| stats_temp_directory | /var/run/postgresql/9.5-main.pg_stat_tmp | 0 | /var/run/postgresql/9.5-main.pg_stat_tmp | pg_stat_tmp | f |
| track_activities | on | 0 | on | on | f |
| track_counts | on | 0 | on | on | f |
| track_functions | none | 0 | none | none | f |
| track_io_timing | 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 |
| default_with_oids | off | 0 | off | off | f |
| escape_string_warning | on | 0 | on | on | f |
| lo_compat_privileges | off | 0 | off | off | f |
| operator_precedence_warning | off | 0 | off | off | f |
| quote_all_identifiers | off | 0 | off | off | f |
| sql_inheritance | on | 0 | on | on | f |
| standard_conforming_strings | on | 0 | on | on | f |
| synchronize_seqscans | on | 0 | on | on | f |
| Write-Ahead Log / Archiving | |||||
| Name | Current | Unit | Reset val | Boot val | Pending restart |
| archive_command | (disabled) | 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.5 | 0 | 0.5 | 0.5 | f |
| checkpoint_timeout | 300 | s | 300 | 300 | f |
| checkpoint_warning | 30 | s | 30 | 30 | f |
| max_wal_size | 64 | 16MB | 64 | 64 | f |
| min_wal_size | 5 | 16MB | 5 | 5 | 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_level | minimal | 0 | minimal | minimal | f |
| wal_log_hints | off | 0 | off | off | f |
| wal_sync_method | fdatasync | 0 | fdatasync | fdatasync | f |
| wal_writer_delay | 200 | ms | 200 | 200 | f |