Skip to content

Instantly share code, notes, and snippets.

@skehlet
Created May 17, 2016 00:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save skehlet/47c7f92daa0bd3d1a3aee2bb001da140 to your computer and use it in GitHub Desktop.
Save skehlet/47c7f92daa0bd3d1a3aee2bb001da140 to your computer and use it in GitHub Desktop.
postgres=# SELECT version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44), 64-bit
(1 row)
postgres=# SELECT name, current_setting(name), SOURCE
postgres-# FROM pg_settings
postgres-# WHERE SOURCE NOT IN ('default', 'override');
name | current_setting | source
---------------------------------+---------------------------------+--------------------
application_name | psql | client
archive_command | cd . | 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
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 | localhost,10.80.64.40 | 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_standby_archive_delay | 30min | configuration file
max_standby_streaming_delay | 30min | configuration file
max_wal_senders | 1 | configuration file
port | 5432 | configuration file
shared_buffers | 8GB | configuration file
shared_preload_libraries | pg_stat_statements,repmgr_funcs | configuration file
tcp_keepalives_count | 9 | configuration file
tcp_keepalives_idle | 1500 | configuration file
tcp_keepalives_interval | 75 | 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_level | hot_standby | configuration file
work_mem | 10MB | configuration file
(47 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment