name | current_setting | source | ------------------------------------+--------------------------------------------+----------------------+ application_name | psql | client | archive_mode | on | configuration file | auto_explain.log_analyze | on | configuration file | auto_explain.log_min_duration | 0 | configuration file | auto_explain.log_nested_statements | on | configuration file | client_encoding | UTF8 | client | cluster_name | HB_LUX | configuration file | data_checksums | on | override | DateStyle | ISO, MDY | configuration file | default_text_search_config | pg_catalog.english | configuration file | dynamic_shared_memory_type | posix | configuration file | effective_cache_size | 4GB | configuration file | lc_collate | C | override | lc_ctype | en_US.UTF-8 | override | 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_destination | stderr | configuration file | log_directory | /usr/local/hb/zz_log/pg_log_hblux | configuration file | log_line_prefix | LHB %a %t %i %e %2l:> | configuration file | log_statement | mod | configuration file | log_temp_files | 0 | configuration file | log_timezone | Europe/Berlin | configuration file | logging_collector | on | configuration file | maintenance_work_mem | 128MB | configuration file | max_connections | 20 | configuration file | max_stack_depth | 2MB | environment variable | max_wal_size | 1GB | configuration file | min_wal_size | 80MB | configuration file | pg_prewarm.autoprewarm | off | configuration file | pg_stat_statements.max | 8000 | configuration file | pg_stat_statements.track | all | configuration file | random_page_cost | 1 | configuration file | search_path | public, archiv, ablage, admin | database | server_encoding | UTF8 | override | server_version | 13.2 | default | shared_buffers | 512MB | configuration file | shared_preload_libraries | auto_explain,pg_stat_statements,pg_prewarm | configuration file | temp_buffers | 32MB | configuration file | TimeZone | Europe/Berlin | configuration file | transaction_deferrable | off | override | transaction_isolation | read committed | override | transaction_read_only | off | override | update_process_title | off | configuration file | wal_buffers | 16MB | override | wal_compression | on | configuration file | wal_segment_size | 16MB | override | work_mem | 64MB | configuration file | (50 rows)