Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- name | | pending_restart
- ----------------------------------------+------------------------------------------------+-----------------
- allow_system_table_mods | off | f
- application_name | psql | f
- archive_command | /etc/rds/dbbin/pgscripts/rds_wal_archive %p | f
- archive_mode | on | f
- archive_timeout | 300 | f
- array_nulls | on | f
- authentication_timeout | 60 | f
- autovacuum | on | f
- autovacuum_analyze_scale_factor | 0.05 | f
- autovacuum_analyze_threshold | 50 | f
- autovacuum_freeze_max_age | 200000000 | f
- autovacuum_max_workers | 3 | f
- autovacuum_multixact_freeze_max_age | 400000000 | f
- autovacuum_naptime | 30 | f
- autovacuum_vacuum_cost_delay | 20 | f
- autovacuum_vacuum_cost_limit | -1 | f
- autovacuum_vacuum_scale_factor | 0.1 | f
- autovacuum_vacuum_threshold | 50 | f
- autovacuum_work_mem | -1 | f
- backend_flush_after | 0 | f
- backslash_quote | safe_encoding | f
- bgwriter_delay | 200 | f
- bgwriter_flush_after | 64 | f
- bgwriter_lru_maxpages | 100 | f
- bgwriter_lru_multiplier | 2 | f
- block_size | 8192 | f
- bonjour | off | f
- bonjour_name | | f
- bytea_output | hex | f
- check_function_bodies | on | f
- checkpoint_completion_target | 0.9 | f
- checkpoint_flush_after | 32 | f
- checkpoint_timeout | 300 | f
- checkpoint_warning | 30 | f
- client_encoding | UTF8 | f
- client_min_messages | notice | f
- cluster_name | | f
- commit_delay | 0 | f
- commit_siblings | 5 | f
- config_file | /rdsdbdata/config/postgresql.conf | f
- constraint_exclusion | partition | f
- cpu_index_tuple_cost | 0.005 | f
- cpu_operator_cost | 0.0025 | f
- cpu_tuple_cost | 0.01 | f
- cursor_tuple_fraction | 0.1 | f
- data_checksums | on | f
- data_directory | /rdsdbdata/db | f
- DateStyle | ISO, MDY | f
- db_user_namespace | off | f
- deadlock_timeout | 1000 | f
- debug_assertions | off | f
- debug_pretty_print | on | f
- debug_print_parse | off | f
- debug_print_plan | off | f
- debug_print_rewritten | off | f
- default_statistics_target | 100 | f
- default_tablespace | | f
- default_text_search_config | pg_catalog.simple | f
- default_transaction_deferrable | off | f
- default_transaction_isolation | read committed | f
- default_transaction_read_only | off | f
- default_with_oids | off | f
- dynamic_library_path | $libdir | f
- dynamic_shared_memory_type | posix | f
- effective_cache_size | 7851762 | f
- effective_io_concurrency | 1 | f
- enable_bitmapscan | on | f
- enable_hashagg | on | f
- enable_hashjoin | on | f
- enable_indexonlyscan | on | f
- enable_indexscan | on | f
- enable_material | on | f
- enable_mergejoin | on | f
- enable_nestloop | on | f
- enable_seqscan | on | f
- enable_sort | on | f
- enable_tidscan | on | f
- escape_string_warning | on | f
- event_source | PostgreSQL | f
- exit_on_error | off | f
- external_pid_file | | f
- extra_float_digits | 0 | f
- force_parallel_mode | off | f
- from_collapse_limit | 8 | f
- fsync | on | f
- full_page_writes | on | f
- geqo | on | f
- geqo_effort | 5 | f
- geqo_generations | 0 | f
- geqo_pool_size | 0 | f
- geqo_seed | 0 | f
- geqo_selection_bias | 2 | f
- geqo_threshold | 12 | f
- gin_fuzzy_search_limit | 0 | f
- gin_pending_list_limit | 4096 | f
- hba_file | /rdsdbdata/config/pg_hba.conf | f
- hot_standby | off | f
- hot_standby_feedback | off | f
- huge_pages | on | f
- ident_file | /rdsdbdata/config/pg_ident.conf | f
- idle_in_transaction_session_timeout | 86400000 | f
- ignore_checksum_failure | off | f
- ignore_system_indexes | off | f
- integer_datetimes | on | f
- IntervalStyle | postgres | f
- join_collapse_limit | 8 | f
- krb_caseins_users | off | f
- krb_server_keyfile | | f
- lc_collate | en_US.UTF-8 | f
- lc_ctype | en_US.UTF-8 | f
- lc_messages | | f
- lc_monetary | C | f
- lc_numeric | C | f
- lc_time | C | f
- listen_addresses | * | f
- lo_compat_privileges | off | f
- local_preload_libraries | | f
- lock_timeout | 0 | f
- log_autovacuum_min_duration | -1 | f
- log_checkpoints | on | f
- log_connections | off | f
- log_destination | stderr | f
- log_directory | /rdsdbdata/log/error | f
- log_disconnections | off | f
- log_duration | off | f
- log_error_verbosity | default | f
- log_executor_stats | off | f
- log_file_mode | 0644 | f
- log_filename | postgresql.log.%Y-%m-%d-%H | f
- log_hostname | on | f
- log_line_prefix | %t:%r:%u@%d:[%p]: | f
- log_lock_waits | off | f
- log_min_duration_statement | 250 | f
- log_min_error_statement | error | f
- log_min_messages | warning | f
- log_parser_stats | off | f
- log_planner_stats | off | f
- log_replication_commands | off | f
- log_rotation_age | 60 | f
- log_rotation_size | 10240 | f
- log_statement | none | f
- log_statement_stats | off | f
- log_temp_files | -1 | f
- log_timezone | UTC | f
- log_truncate_on_rotation | off | f
- logging_collector | on | f
- maintenance_work_mem | 2059264 | f
- max_connections | 5000 | f
- max_files_per_process | 1000 | f
- max_function_args | 100 | f
- max_identifier_length | 63 | f
- max_index_keys | 32 | f
- max_locks_per_transaction | 64 | f
- max_parallel_workers_per_gather | 0 | f
- max_pred_locks_per_transaction | 64 | f
- max_prepared_transactions | 0 | f
- max_replication_slots | 5 | f
- max_stack_depth | 6144 | f
- max_standby_archive_delay | 30000 | f
- max_standby_streaming_delay | 30000 | f
- max_wal_senders | 10 | f
- max_wal_size | 128 | f
- max_worker_processes | 8 | f
- min_parallel_relation_size | 1024 | f
- min_wal_size | 16 | f
- old_snapshot_threshold | -1 | f
- operator_precedence_warning | off | f
- parallel_setup_cost | 1000 | f
- parallel_tuple_cost | 0.1 | f
- password_encryption | on | f
- pg_stat_statements.max | 5000 | f
- pg_stat_statements.save | on | f
- pg_stat_statements.track | top | f
- pg_stat_statements.track_utility | on | f
- port | 5432 | f
- post_auth_delay | 0 | f
- pre_auth_delay | 0 | f
- quote_all_identifiers | off | f
- random_page_cost | 4 | f
- rds.force_admin_logging_level | disabled | f
- rds.force_autovacuum_logging_level | disabled | f
- rds.internal_databases | rdsadmin,template0 | f
- rds.rds_superuser_reserved_connections | 2 | f
- rds.restrict_logical_slot_creation | off | f
- rds.superuser_variables | session_replication_role | f
- replacement_sort_tuples | 150000 | f
- restart_after_crash | on | f
- row_security | on | f
- search_path | "$user", public | f
- segment_size | 131072 | f
- seq_page_cost | 1 | f
- server_encoding | UTF8 | f
- server_version | 9.6.6 | f
- server_version_num | 90606 | f
- session_preload_libraries | | f
- session_replication_role | origin | f
- shared_buffers | 3925881 | f
- shared_preload_libraries | rdsutils,pg_stat_statements | f
- sql_inheritance | on | f
- ssl | on | f
- ssl_ca_file | /rdsdbdata/rds-metadata/ca-cert.pem | f
- ssl_cert_file | /rdsdbdata/rds-metadata/server-cert.pem | f
- ssl_ciphers | HIGH:MEDIUM:+3DES:!aNULL | f
- ssl_crl_file | | f
- ssl_ecdh_curve | prime256v1 | f
- ssl_key_file | /rdsdbdata/rds-metadata/server-key.pem | f
- ssl_prefer_server_ciphers | on | f
- standard_conforming_strings | on | f
- statement_timeout | 0 | f
- stats_temp_directory | /rdsdbdata/db/pg_stat_tmp | f
- superuser_reserved_connections | 3 | f
- synchronize_seqscans | on | f
- synchronous_commit | on | f
- synchronous_standby_names | | f
- syslog_facility | local0 | f
- syslog_ident | postgres | f
- syslog_sequence_numbers | on | f
- syslog_split_messages | on | f
- tcp_keepalives_count | 2 | f
- tcp_keepalives_idle | 300 | f
- tcp_keepalives_interval | 30 | f
- temp_buffers | 1024 | f
- temp_file_limit | -1 | f
- temp_tablespaces | | f
- TimeZone | UTC | f
- timezone_abbreviations | Default | f
- trace_notify | off | f
- trace_recovery_messages | log | f
- trace_sort | off | f
- track_activities | on | f
- track_activity_query_size | 1024 | f
- track_commit_timestamp | off | f
- track_counts | on | f
- track_functions | none | f
- track_io_timing | off | f
- transaction_deferrable | off | f
- transaction_isolation | read committed | f
- transaction_read_only | off | f
- transform_null_equals | off | f
- unix_socket_directories | /tmp | f
- unix_socket_group | rdsdb | f
- unix_socket_permissions | 0700 | f
- update_process_title | on | f
- vacuum_cost_delay | 0 | f
- vacuum_cost_limit | 200 | f
- vacuum_cost_page_dirty | 20 | f
- vacuum_cost_page_hit | 1 | f
- vacuum_cost_page_miss | 10 | f
- vacuum_defer_cleanup_age | 0 | f
- vacuum_freeze_min_age | 50000000 | f
- vacuum_freeze_table_age | 150000000 | f
- vacuum_multixact_freeze_min_age | 5000000 | f
- vacuum_multixact_freeze_table_age | 150000000 | f
- wal_block_size | 8192 | f
- wal_buffers | 2048 | f
- wal_compression | off | f
- wal_keep_segments | 32 | f
- wal_level | replica | f
- wal_log_hints | off | f
- wal_receiver_status_interval | 10 | f
- wal_receiver_timeout | 30000 | f
- wal_retrieve_retry_interval | 5000 | f
- wal_segment_size | 2048 | f
- wal_sender_timeout | 30000 | f
- wal_sync_method | fdatasync | f
- wal_writer_delay | 200 | f
- wal_writer_flush_after | 128 | f
- work_mem | 51200 | f
- xmlbinary | base64 | f
- xmloption | content | f
- zero_damaged_pages | off | f
- (272 rows)
- Time: 829.685 ms
- rds.extensions |
- address_standardizer,address_standardizer_data_us,bloom,btree_gin,btree_gist,chkpass,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,
- fuzzystrmatch,hll,hstore,hstore_plperl,intagg,intarray,ip4r,isn,log_fdw,ltree,orafce,pgaudit,pgcrypto,pgrouting,pgrowlocks,
- pgstattuple,pg_buffercache,pg_freespacemap,pg_hint_plan,pg_prewarm,pg_repack,pg_stat_statements,pg_trgm,pg_visibility,plcoffee,plls
- plperl,plpgsql,pltcl,plv8,postgis,postgis_tiger_geocoder,postgis_topology,postgres_fdw,prefix,sslinfo,tablefunc,test_parser,
- tsearch2,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp
Add Comment
Please, Sign In to add comment
