name | setting --------------------------------+--------------------------------------- australian_timezones | off authentication_timeout | 60 autocommit | on checkpoint_segments | 64 checkpoint_timeout | 300 client_encoding | SQL_ASCII client_min_messages | notice commit_delay | 0 commit_siblings | 5 cpu_index_tuple_cost | 0.001 cpu_operator_cost | 0.0025 cpu_tuple_cost | 0.01 DateStyle | ISO with US (NonEuropean) conventions db_user_namespace | off deadlock_timeout | 1000 debug_pretty_print | off debug_print_parse | off debug_print_plan | off debug_print_rewritten | off default_statistics_target | 10 default_transaction_isolation | read committed dynamic_library_path | $libdir effective_cache_size | 1e+07 enable_hashjoin | on enable_indexscan | on enable_mergejoin | on enable_nestloop | on enable_seqscan | on enable_sort | on enable_tidscan | on explain_pretty_print | on fixbtree | on fsync | on geqo | on geqo_effort | 1 geqo_generations | 0 geqo_pool_size | 0 geqo_random_seed | -1 geqo_selection_bias | 2 geqo_threshold | 11 hostname_lookup | off krb_server_keyfile | unset lc_messages | en_US.UTF-8 lc_monetary | en_US.UTF-8 lc_numeric | en_US.UTF-8 lc_time | en_US.UTF-8 log_connections | on log_duration | off log_min_error_statement | panic log_pid | off log_statement | on log_timestamp | off max_connections | 64 max_expr_depth | 10000 max_files_per_process | 1000 max_fsm_pages | 200000 max_fsm_relations | 1500 max_locks_per_transaction | 64 password_encryption | on port | 5432 pre_auth_delay | 0 random_page_cost | 1.5 search_path | $user,public server_encoding | SQL_ASCII server_min_messages | debug2 shared_buffers | 5000 show_executor_stats | off show_parser_stats | off show_planner_stats | off show_source_port | off show_statement_stats | off silent_mode | off sort_mem | 1024 sql_inheritance | on ssl | off statement_timeout | 0 stats_block_level | off stats_command_string | off stats_reset_on_server_start | on stats_row_level | off stats_start_collector | on superuser_reserved_connections | 2 syslog | 0 syslog_facility | LOCAL0 syslog_ident | postgres tcpip_socket | on TimeZone | unknown trace_notify | off TRANSACTION ISOLATION LEVEL | READ COMMITTED transform_null_equals | off unix_socket_directory | unset unix_socket_group | unset unix_socket_permissions | 511 vacuum_mem | 8192 virtual_host | unset wal_buffers | 64 wal_debug | 0 wal_sync_method | fdatasync zero_damaged_pages | off (99 rows)