name | unit | setting ---------------------------------------------------------+------+----------------------------------------------------------------------------------------------- ---------------------------------------------------------------------- DateStyle | | ISO, MDY IntervalStyle | | postgres TimeZone | | Etc/UTC allow_in_place_tablespaces | | off allow_system_table_mods | | off application_name | | psql archive_cleanup_command | | archive_command | | (disabled) archive_mode | | off archive_timeout | s | 1800 array_nulls | | on authentication_timeout | s | 60 autovacuum | | on autovacuum_analyze_scale_factor | | 0.02 autovacuum_analyze_threshold | | 50 autovacuum_freeze_max_age | | 200000000 autovacuum_max_workers | | 2 autovacuum_multixact_freeze_max_age | | 400000000 autovacuum_naptime | s | 1 autovacuum_vacuum_cost_delay | ms | 2 autovacuum_vacuum_cost_limit | | 1000 autovacuum_vacuum_insert_scale_factor | | 0.2 autovacuum_vacuum_insert_threshold | | 1000 autovacuum_vacuum_scale_factor | | 0.01 autovacuum_vacuum_threshold | | 50 autovacuum_work_mem | kB | -1 backend_flush_after | 8kB | 0 backslash_quote | | safe_encoding backtrace_functions | | bgwriter_delay | ms | 200 bgwriter_flush_after | 8kB | 64 bgwriter_lru_maxpages | | 100 bgwriter_lru_multiplier | | 2 block_size | | 8192 bonjour | | off bonjour_name | | bytea_output | | hex check_function_bodies | | on checkpoint_completion_target | | 0.9 checkpoint_flush_after | 8kB | 32 checkpoint_timeout | s | 300 checkpoint_warning | s | 30 client_connection_check_interval | ms | 0 client_encoding | | UTF8 client_min_messages | | notice cluster_name | | zabbix commit_delay | | 0 commit_siblings | | 5 compute_query_id | | auto config_file | | /mnt/db/14/postgresql.conf constraint_exclusion | | partition cpu_index_tuple_cost | | 0.005 cpu_operator_cost | | 0.0025 cpu_tuple_cost | | 0.01 cursor_tuple_fraction | | 0.1 data_checksums | | off data_directory | | /mnt/db/14 data_directory_mode | | 0700 data_sync_retry | | off db_user_namespace | | off deadlock_timeout | ms | 1000 debug_assertions | | off debug_discard_caches | | 0 debug_pretty_print | | on debug_print_parse | | off debug_print_plan | | off debug_print_rewritten | | off default_statistics_target | | 1000 default_table_access_method | | heap default_tablespace | | default_text_search_config | | pg_catalog.english default_toast_compression | | pglz default_transaction_deferrable | | off default_transaction_isolation | | read committed default_transaction_read_only | | off dynamic_library_path | | $libdir dynamic_shared_memory_type | | posix effective_cache_size | 8kB | 6291456 effective_io_concurrency | | 200 enable_async_append | | on enable_bitmapscan | | on enable_gathermerge | | on enable_hashagg | | on enable_hashjoin | | on enable_incremental_sort | | on enable_indexonlyscan | | on enable_indexscan | | on enable_material | | on enable_memoize | | on enable_mergejoin | | on enable_nestloop | | on enable_parallel_append | | on enable_parallel_hash | | on enable_partition_pruning | | on enable_partitionwise_aggregate | | off enable_partitionwise_join | | off enable_seqscan | | on enable_sort | | on enable_tidscan | | on escape_string_warning | | on event_source | | PostgreSQL exit_on_error | | off extension_destdir | | external_pid_file | | extra_float_digits | | 1 force_parallel_mode | | off from_collapse_limit | | 8 fsync | | on full_page_writes | | on geqo | | on geqo_effort | | 5 geqo_generations | | 0 geqo_pool_size | | 0 geqo_seed | | 0 geqo_selection_bias | | 2 geqo_threshold | | 12 gin_fuzzy_search_limit | | 0 gin_pending_list_limit | kB | 4096 hash_mem_multiplier | | 1 hba_file | | /mnt/db/14/pg_hba.conf hot_standby | | on hot_standby_feedback | | off huge_page_size | kB | 0 huge_pages | | try ident_file | | /mnt/db/14/pg_ident.conf idle_in_transaction_session_timeout | ms | 0 idle_session_timeout | ms | 0 ignore_checksum_failure | | off ignore_invalid_pages | | off ignore_system_indexes | | off in_hot_standby | | off integer_datetimes | | on jit | | on jit_above_cost | | 100000 jit_debugging_support | | off jit_dump_bitcode | | off jit_expressions | | on jit_inline_above_cost | | 500000 jit_optimize_above_cost | | 500000 jit_profiling_support | | off jit_provider | | llvmjit jit_tuple_deforming | | on join_collapse_limit | | 8 krb_caseins_users | | off krb_server_keyfile | | FILE:/etc/postgresql-common/krb5.keytab lc_collate | | C.UTF-8 lc_ctype | | C.UTF-8 lc_messages | | C.UTF-8 lc_monetary | | C.UTF-8 lc_numeric | | C.UTF-8 lc_time | | C.UTF-8 listen_addresses | | 0.0.0.0,127.0.0.1 lo_compat_privileges | | off local_preload_libraries | | lock_timeout | ms | 0 log_autovacuum_min_duration | ms | -1 log_checkpoints | | on log_connections | | off log_destination | | stderr log_directory | | log log_disconnections | | off log_duration | | off log_error_verbosity | | default log_executor_stats | | off log_file_mode | | 0600 log_filename | | postgresql-%Y-%m-%d.log log_hostname | | off log_line_prefix | | %m pid=[%p] sql_state=%e user=%u host=%r log_lock_waits | | on log_min_duration_sample | ms | -1 log_min_duration_statement | ms | -1 log_min_error_statement | | error log_min_messages | | warning log_parameter_max_length | B | -1 log_parameter_max_length_on_error | B | 0 log_parser_stats | | off log_planner_stats | | off log_recovery_conflict_waits | | off log_replication_commands | | off log_rotation_age | min | 1440 log_rotation_size | kB | 0 log_statement | | none log_statement_sample_rate | | 1 log_statement_stats | | off log_temp_files | kB | 0 log_timezone | | Etc/UTC log_transaction_sample_rate | | 0 log_truncate_on_rotation | | on logging_collector | | on logical_decoding_work_mem | kB | 65536 maintenance_io_concurrency | | 10 maintenance_work_mem | kB | 2097152 max_connections | | 300 max_files_per_process | | 4096 max_function_args | | 100 max_identifier_length | | 63 max_index_keys | | 32 max_locks_per_transaction | | 64 max_logical_replication_workers | | 4 max_parallel_maintenance_workers | | 4 max_parallel_workers | | 10 max_parallel_workers_per_gather | | 4 max_pred_locks_per_page | | 2 max_pred_locks_per_relation | | -2 max_pred_locks_per_transaction | | 64 max_prepared_transactions | | 0 max_replication_slots | | 15 max_slot_wal_keep_size | MB | -1 max_stack_depth | kB | 2048 max_standby_archive_delay | ms | 30000 max_standby_streaming_delay | ms | 30000 max_sync_workers_per_subscription | | 2 max_wal_senders | | 15 max_wal_size | MB | 4096 max_worker_processes | | 2 min_dynamic_shared_memory | MB | 0 min_parallel_index_scan_size | 8kB | 64 min_parallel_table_scan_size | 8kB | 1024 min_wal_size | MB | 1024 old_snapshot_threshold | min | -1 parallel_leader_participation | | on parallel_setup_cost | | 1000 parallel_tuple_cost | | 0.1 password_encryption | | md5 pg_stat_statements.max | | 10000 pg_stat_statements.save | | off pg_stat_statements.track | | all pg_stat_statements.track_planning | | off pg_stat_statements.track_utility | | on plan_cache_mode | | auto plpgsql.check_asserts | | on plpgsql.extra_errors | | none plpgsql.extra_warnings | | none plpgsql.print_strict_params | | off plpgsql.variable_conflict | | error port | | 5432 post_auth_delay | s | 0 pre_auth_delay | s | 0 primary_conninfo | | user=replication passfile=/var/lib/postgresql/pgpass host=10.1.1.11 port=5432 sslmode=prefer application_name=SRV-DB2 gssencmode=prefer channel_binding=prefer primary_slot_name | | srv_db2 promote_trigger_file | | quote_all_identifiers | | off random_page_cost | | 1.1 recovery_end_command | | recovery_init_sync_method | | fsync recovery_min_apply_delay | ms | 0 recovery_target | | recovery_target_action | | pause recovery_target_inclusive | | on recovery_target_lsn | | recovery_target_name | | recovery_target_time | | recovery_target_timeline | | latest recovery_target_xid | | remove_temp_files_after_crash | | on restart_after_crash | | on restore_command | | restrict_nonsystem_relation_kind | | row_security | | on search_path | | "$user", public segment_size | 8kB | 131072 seq_page_cost | | 1 server_encoding | | UTF8 server_version | | 14.15 (Ubuntu 14.15-0ubuntu0.22.04.1) server_version_num | | 140015 session_preload_libraries | | session_replication_role | | origin shared_buffers | 8kB | 5242880 shared_memory_type | | mmap shared_preload_libraries | | pg_stat_statements,timescaledb ssl | | off ssl_ca_file | | ssl_cert_file | | server.crt ssl_ciphers | | HIGH:MEDIUM:+3DES:!aNULL ssl_crl_dir | | ssl_crl_file | | ssl_dh_params_file | | ssl_ecdh_curve | | prime256v1 ssl_key_file | | server.key ssl_library | | OpenSSL ssl_max_protocol_version | | ssl_min_protocol_version | | TLSv1.2 ssl_passphrase_command | | ssl_passphrase_command_supports_reload | | off ssl_prefer_server_ciphers | | on standard_conforming_strings | | on statement_timeout | ms | 0 stats_temp_directory | | pg_stat_tmp superuser_reserved_connections | | 5 synchronize_seqscans | | on synchronous_commit | | off synchronous_standby_names | | syslog_facility | | local0 syslog_ident | | postgres syslog_sequence_numbers | | on syslog_split_messages | | on tcp_keepalives_count | | 0 tcp_keepalives_idle | s | 0 tcp_keepalives_interval | s | 0 tcp_user_timeout | ms | 0 temp_buffers | 8kB | 1024 temp_file_limit | kB | -1 temp_tablespaces | | timescaledb.auto_sparse_indexes | | on timescaledb.bgw_launcher_poll_time | | 60000 timescaledb.bgw_log_level | | warning timescaledb.compression_orderby_default_function | | _timescaledb_functions.get_orderby_defaults timescaledb.compression_segmentby_default_function | | _timescaledb_functions.get_segmentby_defaults timescaledb.debug_compression_path_info | | off timescaledb.disable_load | | off timescaledb.enable_bulk_decompression | | on timescaledb.enable_cagg_create | | on timescaledb.enable_cagg_reorder_groupby | | on timescaledb.enable_cagg_watermark_constify | | on timescaledb.enable_chunk_append | | on timescaledb.enable_chunk_skipping | | off timescaledb.enable_chunkwise_aggregation | | on timescaledb.enable_compressed_direct_batch_delete | | on timescaledb.enable_compression_indexscan | | off timescaledb.enable_compression_wal_markers | | on timescaledb.enable_constraint_aware_append | | on timescaledb.enable_constraint_exclusion | | on timescaledb.enable_decompression_sorted_merge | | on timescaledb.enable_delete_after_compression | | off timescaledb.enable_deprecation_warnings | | on timescaledb.enable_dml_decompression | | on timescaledb.enable_dml_decompression_tuple_filtering | | on timescaledb.enable_foreign_key_propagation | | on timescaledb.enable_hypertable_compression | | on timescaledb.enable_hypertable_create | | on timescaledb.enable_job_execution_logging | | off timescaledb.enable_merge_on_cagg_refresh | | off timescaledb.enable_now_constify | | on timescaledb.enable_optimizations | | on timescaledb.enable_ordered_append | | on timescaledb.enable_parallel_chunk_append | | on timescaledb.enable_policy_create | | on timescaledb.enable_qual_propagation | | on timescaledb.enable_rowlevel_compression_locking | | off timescaledb.enable_runtime_exclusion | | on timescaledb.enable_skipscan | | on timescaledb.enable_tiered_reads | | on timescaledb.enable_transparent_decompression | | on timescaledb.enable_tss_callbacks | | on timescaledb.enable_vectorized_aggregation | | on timescaledb.last_tuned | | timescaledb.last_tuned_version | | timescaledb.license | | timescale timescaledb.materializations_per_refresh_window | | 10 timescaledb.max_background_workers | | 16 timescaledb.max_cached_chunks_per_hypertable | | 1024 timescaledb.max_open_chunks_per_insert | | 1024 timescaledb.max_tuples_decompressed_per_dml_transaction | | 100000 timescaledb.restoring | | off timescaledb.telemetry_level | | basic timescaledb_osm.disable_load | | off timescaledb_telemetry.cloud | | timezone_abbreviations | | Default trace_notify | | off trace_recovery_messages | | log trace_sort | | off track_activities | | on track_activity_query_size | B | 1024 track_commit_timestamp | | off track_counts | | on track_functions | | all track_io_timing | | on track_wal_io_timing | | off transaction_deferrable | | off transaction_isolation | | read committed transaction_read_only | | off transform_null_equals | | off unix_socket_directories | | /var/run/postgresql unix_socket_group | | unix_socket_permissions | | 0777 update_process_title | | on vacuum_cost_delay | ms | 0 vacuum_cost_limit | | 200 vacuum_cost_page_dirty | | 20 vacuum_cost_page_hit | | 1 vacuum_cost_page_miss | | 2 vacuum_defer_cleanup_age | | 0 vacuum_failsafe_age | | 1600000000 vacuum_freeze_min_age | | 50000000 vacuum_freeze_table_age | | 150000000 vacuum_multixact_failsafe_age | | 1600000000 vacuum_multixact_freeze_min_age | | 5000000 vacuum_multixact_freeze_table_age | | 150000000 wal_block_size | | 8192 wal_buffers | 8kB | 4096 wal_compression | | on wal_consistency_checking | | wal_init_zero | | on wal_keep_size | MB | 128 wal_level | | replica wal_log_hints | | on wal_receiver_create_temp_slot | | off wal_receiver_status_interval | s | 10 wal_receiver_timeout | ms | 0 wal_recycle | | on wal_retrieve_retry_interval | ms | 5000 wal_segment_size | B | 16777216 wal_sender_timeout | ms | 0 wal_skip_threshold | kB | 2048 wal_sync_method | | fdatasync wal_writer_delay | ms | 200 wal_writer_flush_after | 8kB | 128 work_mem | kB | 32768 xmlbinary | | base64 xmloption | | content zero_damaged_pages | | off (411 rows)