Tables, views and functions reference ===================================== The reference section is a definitive listing of all functions, views, and commands available in EDB Postgres Distributed. :ref:`User visible catalogs and views ` ------------- - :ref:`bdr.camo_decision_journal ` - :ref:`bdr.commit_decisions ` - :ref:`bdr.commit_scopes ` - :ref:`bdr.conflict_history ` - :ref:`bdr.conflict_history_summary ` - :ref:`bdr.consensus_kv_data ` - :ref:`bdr.crdt_handlers ` - :ref:`bdr.ddl_replication ` - :ref:`bdr.depend ` - :ref:`bdr.failover_replication_slots ` - :ref:`bdr.global_consensus_journal ` - :ref:`bdr.global_consensus_journal_details ` - :ref:`bdr.global_consensus_response_journal ` - :ref:`bdr.global_lock ` - :ref:`bdr.global_locks ` - :ref:`bdr.group_camo_details ` - :ref:`bdr.group_lease ` - :ref:`bdr.group_raft_details ` - :ref:`bdr.group_replslots_details ` - :ref:`bdr.group_subscription_summary ` - :ref:`bdr.group_versions_details ` - :ref:`bdr.leader_tenure_backlog ` - :ref:`bdr.local_consensus_snapshot ` - :ref:`bdr.local_consensus_state ` - :ref:`bdr.local_node ` - :ref:`bdr.local_node_summary ` - :ref:`bdr.local_sync_status ` - :ref:`bdr.node_config ` - :ref:`bdr.node_catchup_info ` - :ref:`bdr.node_catchup_info_details ` - :ref:`bdr.node_conflict_resolvers ` - :ref:`bdr.node_group_config ` - :ref:`bdr.node_group_replication_sets ` - :ref:`bdr.node_group_summary ` - :ref:`bdr.node_local_info ` - :ref:`bdr.node_log_config ` - :ref:`bdr.node_peer_progress_mapping ` - :ref:`bdr.node_replication_rates ` - :ref:`bdr.node_slots ` - :ref:`bdr.node_summary ` - :ref:`bdr.parted_origin_catchup_info ` - :ref:`bdr.parted_origin_catchup_info_details ` - :ref:`bdr.pending_failed_changes ` - :ref:`bdr.pending_failed_changes_sql ` - :ref:`bdr.pgd_largeobject ` - :ref:`bdr.pgd_largeobject_metadata ` - :ref:`bdr.queue ` - :ref:`bdr.replication_set ` - :ref:`bdr.replication_set_table ` - :ref:`bdr.replication_set_ddl ` - :ref:`bdr.replication_sets ` - :ref:`bdr.resolved_transactions ` - :ref:`bdr.resolved_transactions_info ` - :ref:`bdr.schema_changes ` - :ref:`bdr.sequence_alloc ` - :ref:`bdr.sequences ` - :ref:`bdr.stat_activity ` - :ref:`bdr.stat_commit_scope ` - :ref:`bdr.stat_commit_scope_state ` - :ref:`bdr.stat_connection_manager ` - :ref:`bdr.stat_connection_manager_connections ` - :ref:`bdr.stat_connection_manager_node_stats ` - :ref:`bdr.stat_connection_manager_hba_file_rules ` - :ref:`bdr.stat_raft_followers_state ` - :ref:`bdr.stat_raft_state ` - :ref:`bdr.stat_receiver ` - :ref:`bdr.stat_receiver_transactions ` - :ref:`bdr.stat_reconcile_commit_scope ` - :ref:`bdr.stat_relation ` - :ref:`bdr.stat_routing_candidate_state ` - :ref:`bdr.stat_routing_state ` - :ref:`bdr.stat_subscription ` - :ref:`bdr.stat_worker ` - :ref:`bdr.stat_writer ` - :ref:`bdr.subscription ` - :ref:`bdr.subscription_summary ` - :ref:`bdr.subscription_error_status ` - :ref:`bdr.tables ` - :ref:`bdr.taskmgr_work_queue ` - :ref:`bdr.taskmgr_workitem_status ` - :ref:`bdr.taskmgr_local_work_queue ` - :ref:`bdr.taskmgr_local_workitem_status ` - :ref:`bdr.trigger ` - :ref:`bdr.triggers ` - :ref:`bdr.workers ` - :ref:`bdr.writers ` - :ref:`bdr.worker_tasks ` :ref:`System functions ` -------------- :ref:`Version information functions ` ^^^^^^^^^^^^^^ - :ref:`bdr.bdr_version ` - :ref:`bdr.bdr_version_num ` :ref:`System information functions ` ^^^^^^^^^^^^^^ - :ref:`bdr.get_relation_stats ` - :ref:`bdr.get_subscription_stats ` :ref:`System and progress information parameters ` ^^^^^^^^^^^^^^ - :ref:`bdr.local_node_id ` - :ref:`bdr.last_committed_lsn ` - :ref:`transaction_id ` :ref:`Node status functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.is_node_connected ` - :ref:`bdr.is_node_ready ` :ref:`Consensus function ` ^^^^^^^^^^^^^^^ - :ref:`bdr.consensus_disable ` - :ref:`bdr.consensus_enable ` - :ref:`bdr.consensus_proto_version ` - :ref:`bdr.consensus_snapshot_export ` - :ref:`bdr.consensus_snapshot_import ` - :ref:`bdr.consensus_snapshot_verify ` - :ref:`bdr.get_consensus_status ` - :ref:`bdr.get_raft_status ` - :ref:`bdr.raft_leadership_transfer ` :ref:`Utility functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.transfer_all_leaderships ` - :ref:`bdr.alter_node_kind ` - :ref:`bdr.alter_subscription_skip_changes_upto ` - :ref:`bdr.connection_manager_refresh_pools ` - :ref:`bdr.get_node_sub_apply_lsn ` - :ref:`bdr.get_node_sub_receive_lsn ` - :ref:`bdr.global_lock_table ` - :ref:`bdr.group_lease_override ` - :ref:`bdr.local_group_slot_name ` - :ref:`bdr.node_group_type ` - :ref:`bdr.replicate_ddl_command ` - :ref:`bdr.run_on_all_nodes ` - :ref:`bdr.run_on_group ` - :ref:`bdr.run_on_nodes ` - :ref:`bdr.stat_reset ` - :ref:`bdr.wait_for_apply_queue ` - :ref:`bdr.wait_for_xid_progress ` - :ref:`bdr.wait_node_confirm_lsn ` - :ref:`bdr.wait_slot_confirm_lsn ` :ref:`Global advisory locks ` ^^^^^^^^^^^^^^^ - :ref:`bdr.global_advisory_lock ` - :ref:`bdr.global_advisory_unlock ` :ref:`Monitoring functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.monitor_group_versions ` - :ref:`bdr.monitor_group_raft ` - :ref:`bdr.monitor_local_replslots ` - :ref:`bdr.ts_metrics ` - :ref:`bdr.ts_latest ` - :ref:`bdr.ts_errors ` - :ref:`bdr.ts_samples ` - :ref:`bdr.ts_histogram ` - :ref:`bdr.ts_histogram_distribution ` - :ref:`bdr.ts_histogram_cumulative ` - :ref:`bdr.wal_sender_stats ` - :ref:`bdr.get_decoding_worker_stat ` - :ref:`bdr.lag_control ` :ref:`Routing functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.routing_leadership_transfer ` :ref:`CAMO functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.is_camo_partner_connected ` - :ref:`bdr.is_camo_partner_ready ` - :ref:`bdr.get_configured_camo_partner ` - :ref:`bdr.wait_for_camo_partner_queue ` - :ref:`bdr.camo_transactions_resolved ` - :ref:`bdr.logical_transaction_status ` :ref:`Commit Scope functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.add_commit_scope ` - :ref:`bdr.create_commit_scope ` - :ref:`bdr.alter_commit_scope ` - :ref:`bdr.drop_commit_scope ` - :ref:`bdr.remove_commit_scope ` :ref:`Apply error policy functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.skip_failed_change ` - :ref:`bdr.skip_failed_transaction ` - :ref:`bdr.apply_failed_change ` - :ref:`bdr.apply_failed_transaction ` - :ref:`bdr.modify_failed_change ` - :ref:`bdr.reconstruct_change_sql ` - :ref:`bdr.reconstruct_failed_transaction ` - :ref:`bdr.resolve_failed_transaction ` - :ref:`bdr.analyze_skip_impact ` - :ref:`bdr.analyze_transaction_skip_impact ` - :ref:`bdr.format_skip_analysis ` - :ref:`bdr.alter_subscription_reset_error_counters ` :ref:`Monitoring metrics reference ` --------------- - :ref:`PGD timeseries metrics ` - :ref:`Commit latency histogram ` - :ref:`Cluster state metrics ` - :ref:`Commit scope counters ` - :ref:`Postgres statistics metrics ` - :ref:`Per database ` - :ref:`Non-PGD replication slots ` - :ref:`Instance-wide metrics ` - :ref:`Activity and locks ` :ref:`PGD settings ` --------------- :ref:`CRDTs vs conflict handling/reporting ` ^^^^^^^^^^^^^^^ - :ref:`bdr.default_conflict_detection ` :ref:`Global sequence parameters ` ^^^^^^^^^^^^^^^ - :ref:`bdr.default_sequence_kind ` :ref:`DDL handling ` ^^^^^^^^^^^^^^^ - :ref:`bdr.default_replica_identity ` - :ref:`bdr.ddl_replication ` - :ref:`bdr.role_replication ` - :ref:`bdr.ddl_locking ` - :ref:`bdr.truncate_locking ` :ref:`Global locking ` ^^^^^^^^^^^^^^^ - :ref:`bdr.global_lock_max_locks ` - :ref:`bdr.global_lock_timeout ` - :ref:`bdr.global_lock_statement_timeout ` - :ref:`bdr.global_lock_idle_timeout ` - :ref:`bdr.lock_table_locking ` - :ref:`bdr.predictive_checks ` :ref:`Node management ` ^^^^^^^^^^^^^^^ - :ref:`bdr.replay_progress_frequency ` :ref:`Generic replication ` ^^^^^^^^^^^^^^^ - :ref:`bdr.writers_per_subscription ` - :ref:`bdr.max_writers_per_subscription ` - :ref:`bdr.xact_replication ` - :ref:`bdr.permit_unsafe_commands ` - :ref:`bdr.batch_inserts ` - :ref:`bdr.maximum_clock_skew ` - :ref:`bdr.maximum_clock_skew_action ` - :ref:`bdr.accept_connections ` - :ref:`bdr.writer_input_queue_size ` - :ref:`bdr.writer_output_queue_size ` - :ref:`bdr.min_worker_backoff_delay ` :ref:`CRDTs Overview ` ^^^^^^^^^^^^^^^ - :ref:`bdr.crdt_raw_value ` :ref:`Replicated large objects ` ^^^^^^^^^^^^^^^ - :ref:`bdr.override_large_objects ` :ref:`Server feature/commit scope interoperability ` ^^^^^^^^^^^^^^^ - :ref:`bdr.commit_scopes ` :ref:`Commit At Most Once ` ^^^^^^^^^^^^^^^ - :ref:`bdr.camo_local_mode_delay ` - :ref:`bdr.camo_enable_client_warnings ` :ref:`Using with transaction streaming ` ^^^^^^^^^^^^^^^ - :ref:`Node configuration using bdr.default_streaming_mode ` :ref:`Lag Control ` ^^^^^^^^^^^^^^^ - :ref:`bdr.lag_control_max_commit_delay ` - :ref:`bdr.lag_control_max_lag_size ` - :ref:`bdr.lag_control_max_lag_time ` - :ref:`bdr.lag_control_min_conforming_nodes ` - :ref:`bdr.lag_control_commit_delay_adjust ` - :ref:`bdr.lag_control_sample_interval ` - :ref:`bdr.lag_control_commit_delay_start ` :ref:`Monitoring and logging ` ^^^^^^^^^^^^^^^ - :ref:`bdr.debug_level ` - :ref:`bdr.trace_level ` - :ref:`bdr.track_subscription_apply ` - :ref:`bdr.track_relation_apply ` - :ref:`bdr.track_apply_lock_timing ` - :ref:`bdr.monitor_enabled ` - :ref:`bdr.monitor_prometheus_pg_metrics ` - :ref:`bdr.monitor_ssl_cert_file ` - :ref:`bdr.monitor_ssl_key_file ` - :ref:`bdr.monitor_ssl_ca_file ` :ref:`Decoding worker ` ^^^^^^^^^^^^^^^ - :ref:`bdr.enable_wal_decoder ` - :ref:`bdr.receive_lcr ` - :ref:`bdr.lcr_cleanup_interval ` :ref:`Connectivity settings ` ^^^^^^^^^^^^^^^ - :ref:`bdr.global_connection_timeout ` - :ref:`bdr.global_keepalives ` - :ref:`bdr.global_keepalives_idle ` - :ref:`bdr.global_keepalives_interval ` - :ref:`bdr.global_keepalives_count ` - :ref:`bdr.global_tcp_user_timeout ` :ref:`Connection Manager Authentication ` ^^^^^^^^^^^^^^^ - :ref:`bdr.conn_mgr_server_max_lifetime ` - :ref:`bdr.conn_mgr_worker_threads ` :ref:`Topology settings ` ^^^^^^^^^^^^^^^ - :ref:`bdr.force_full_mesh ` :ref:`Analytics settings ` ^^^^^^^^^^^^^^^ - :ref:`bdr.prefer_analytics_engine ` :ref:`Internal settings - Raft timeouts ` ^^^^^^^^^^^^^^^ - :ref:`bdr.raft_global_election_timeout ` - :ref:`bdr.raft_group_election_timeout ` - :ref:`bdr.raft_response_timeout ` :ref:`Internal settings - Other Raft values ` ^^^^^^^^^^^^^^^ - :ref:`bdr.raft_keep_min_entries ` - :ref:`bdr.raft_log_min_apply_duration ` - :ref:`bdr.raft_log_min_message_duration ` - :ref:`bdr.raft_group_max_connections ` - :ref:`bdr.raft_vacuum_interval ` - :ref:`bdr.raft_vacuum_full_interval ` :ref:`Internal settings - Other values ` ^^^^^^^^^^^^^^^ - :ref:`bdr.backwards_compatibility ` - :ref:`bdr.track_replication_estimates ` - :ref:`bdr.lag_tracker_apply_rate_weight ` - :ref:`bdr.enable_auto_sync_reconcile ` - :ref:`bdr.allow_bdr_schema_changes ` - :ref:`bdr.cds_memory_cache_size ` - :ref:`bdr.commit_decision_min_age ` - :ref:`bdr.prev_leader_wait_timeout ` :ref:`Node management ` --------------- - :ref:`List of node states ` - :ref:`Node-management commands ` - :ref:`bdr_init_physical ` - :ref:`bdr_config ` :ref:`Node management interfaces ` --------------- - :ref:`Group configuration using bdr.alter_node_group_option() ` - :ref:`bdr.alter_node_interface ` - :ref:`bdr.alter_node_option ` - :ref:`bdr.alter_subscription_enable ` - :ref:`bdr.alter_subscription_disable ` - :ref:`bdr.create_node ` - :ref:`bdr.create_node_group ` - :ref:`bdr.drop_node_group ` - :ref:`bdr.join_node_group ` - :ref:`bdr.part_node ` - :ref:`bdr.promote_node ` - :ref:`bdr.switch_node_group ` - :ref:`bdr.sync_node_cancel ` - :ref:`bdr.wait_for_join_completion ` :ref:`Configuring routing thresholds ` --------------- :ref:`Migration to commit scopes ` --------------- - :ref:`Commit scope syntax ` - :ref:`commit_scope_degrade_operation ` - :ref:`Commit scope targets ` - :ref:`ORIGIN_GROUP ` - :ref:`Commit scope groups ` - :ref:`ANY ` - :ref:`ANY NOT ` - :ref:`Effects of MAJORITY and ALL node replication in general ` - :ref:`MAJORITY NOT ` - :ref:`Installing extensions ` - :ref:`ALL NOT ` - :ref:`The confirmation level ` - :ref:`ON RECEIVED ` - :ref:`ON REPLICATED ` - :ref:`ON DURABLE ` - :ref:`ON VISIBLE ` - :ref:`Commit Scope Kinds ` - :ref:`Synchronous Commit ` - :ref:`DEGRADE ON parameters ` - :ref:`commit_scope_degrade_operation ` - :ref:`How Quorum Commit works ` - :ref:`QUORUM COMMIT parameters ` - :ref:`QUORUM COMMIT ABORT ON parameters ` - :ref:`commit_decision settings ` - :ref:`Working with the CAMO partner ` - :ref:`DEGRADE ON parameters ` - :ref:`Lag Control ` - :ref:`LAG CONTROL parameters ` - :ref:`Group Commit (legacy) ` - :ref:`GROUP COMMIT parameters ` - :ref:`QUORUM COMMIT ABORT ON parameters ` - :ref:`DEGRADE ON parameters ` - :ref:`transaction_tracking settings ` - :ref:`conflict_resolution settings ` - :ref:`GROUP COMMIT commit_decision settings ` - :ref:`commit_scope_degrade_operation settings ` :ref:`bdr_read_all_conflicts ` --------------- - :ref:`Column-level conflict detection ` - :ref:`List of conflict types ` - :ref:`Missing-column conflict resolution ` - :ref:`List of conflict resolvers ` - :ref:`Default conflict resolvers ` - :ref:`List of conflict resolutions ` - :ref:`Conflict logging ` :ref:`Column-level conflict functions ` --------------- - :ref:`Using bdr.alter_table_conflict_detection to enable column-level conflict resolution ` - :ref:`bdr.alter_node_set_conflict_resolver ` - :ref:`bdr.alter_node_set_log_config ` :ref:`Replication set management ` --------------- - :ref:`bdr.create_replication_set ` - :ref:`bdr.alter_replication_set ` - :ref:`bdr.drop_replication_set ` - :ref:`bdr.alter_node_replication_sets ` :ref:`Replication set membership ` --------------- - :ref:`bdr.replication_set_add_table ` - :ref:`bdr.replication_set_remove_table ` :ref:`DDL replication filtering ` --------------- - :ref:`bdr.replication_set_add_ddl_filter ` - :ref:`bdr.replication_set_remove_ddl_filter ` :ref:`Testing and tuning commands ` --------------- - :ref:`pgd_bench ` :ref:`Sequences ` --------------- :ref:`Sequence functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.alter_sequence_set_kind ` - :ref:`bdr.extract_timestamp_from_snowflakeid ` - :ref:`bdr.extract_nodeid_from_snowflakeid ` - :ref:`bdr.extract_localseqid_from_snowflakeid ` - :ref:`bdr.timestamp_to_snowflakeid ` - :ref:`bdr.extract_timestamp_from_timeshard ` - :ref:`bdr.extract_nodeid_from_timeshard ` - :ref:`bdr.extract_localseqid_from_timeshard ` - :ref:`bdr.timestamp_to_timeshard ` - :ref:`bdr.galloc_chunk_info ` :ref:`KSUUID v2 functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.gen_ksuuid_v2 ` - :ref:`bdr.ksuuid_v2_cmp ` - :ref:`bdr.extract_timestamp_from_ksuuid_v2 ` :ref:`KSUUID v1 functions ` ^^^^^^^^^^^^^^^ - :ref:`bdr.gen_ksuuid_v2 ` - :ref:`bdr.uuid_v1_cmp ` - :ref:`bdr.extract_timestamp_from_ksuuid_v2 ` :ref:`Replicated large objects ` --------------- :ref:`Large object interface ` ^^^^^^^^^^^^^^^ - :ref:`bdr.lo_creat ` - :ref:`bdr.lo_create ` - :ref:`bdr.lo_open ` - :ref:`bdr.lo_close ` - :ref:`bdr.loread ` - :ref:`bdr.lowrite ` - :ref:`bdr.lo_lseek ` - :ref:`bdr.lo_lseek64 ` - :ref:`bdr.lo_tell