Skip to content

Instantly share code, notes, and snippets.

@skehlet
Created May 26, 2015 23:36
Show Gist options
  • Save skehlet/bcdbc1ce1f212d3b7bb2 to your computer and use it in GitHub Desktop.
Save skehlet/bcdbc1ce1f212d3b7bb2 to your computer and use it in GitHub Desktop.
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment