gistfile1.sql

mydb=> SELECT name, current_setting(name), source
mydb->   FROM pg_settings
mydb->   WHERE source NOT IN ('default', 'override');
              name               | current_setting  |       source       
---------------------------------+------------------+--------------------
 application_name                | psql             | client
 archive_command                 | exit 0           | configuration file
 archive_mode                    | on               | configuration file
 autovacuum                      | on               | configuration file
 autovacuum_analyze_scale_factor | 0.1              | configuration file
 autovacuum_analyze_threshold    | 50               | configuration file
 autovacuum_naptime              | 1min             | configuration file
 autovacuum_vacuum_cost_delay    | 20ms             | configuration file
 autovacuum_vacuum_cost_limit    | 200              | configuration file
 autovacuum_vacuum_scale_factor  | 0.2              | configuration file
 autovacuum_vacuum_threshold     | 50               | configuration file
 checkpoint_completion_target    | 0.9              | configuration file
 checkpoint_segments             | 128              | configuration file
 client_encoding                 | UTF8             | client
 effective_cache_size            | 16GB             | configuration file
 hot_standby                     | on               | configuration file
 hot_standby_feedback            | on               | configuration file
 lc_messages                     | C                | configuration file
 lc_monetary                     | en_US.UTF-8      | configuration file
 lc_numeric                      | en_US.UTF-8      | configuration file
 lc_time                         | en_US.UTF-8      | configuration file
 listen_addresses                | *                | configuration file
 log_autovacuum_min_duration     | 0                | configuration file
 log_checkpoints                 | on               | configuration file
 log_connections                 | on               | configuration file
 log_disconnections              | on               | configuration file
 log_line_prefix                 | %t [%p]: [%l-1]  | configuration file
 log_lock_waits                  | on               | configuration file
 log_min_duration_statement      | 1s               | configuration file
 log_temp_files                  | 0                | configuration file
 maintenance_work_mem            | 512MB            | configuration file
 max_connections                 | 300              | configuration file
 max_stack_depth                 | 8MB              | configuration file
 max_wal_senders                 | 10               | configuration file
 port                            | 5432             | configuration file
 random_page_cost                | 1.3              | configuration file
 shared_buffers                  | 8GB              | configuration file
 track_activity_query_size       | 4096             | configuration file
 vacuum_cost_delay               | 20ms             | configuration file
 vacuum_cost_limit               | 200              | configuration file
 wal_buffers                     | 16MB             | configuration file
 wal_keep_segments               | 5000             | configuration file
 wal_level                       | hot_standby      | configuration file
 work_mem                        | 10MB             | configuration file
(44 rows)