Tables, views and functions reference#
The reference section is a definitive listing of all functions, views, and commands available in EDB Postgres Distributed.
User visible catalogs and views#
System functions#
Version information functions#
System information functions#
System and progress information parameters#
Node status functions#
Consensus function#
Utility functions#
Global advisory locks#
Monitoring functions#
Routing functions#
CAMO functions#
Commit Scope functions#
Apply error policy functions#
Monitoring metrics reference#
PGD settings#
CRDTs vs conflict handling/reporting#
Global sequence parameters#
DDL handling#
Global locking#
Node management#
Generic replication#
CRDTs Overview#
Replicated large objects#
Server feature/commit scope interoperability#
Commit At Most Once#
Using with transaction streaming#
Lag Control#
Monitoring and logging#
Decoding worker#
Connectivity settings#
Connection Manager Authentication#
Topology settings#
Analytics settings#
Internal settings - Raft timeouts#
Internal settings - Other Raft values#
Internal settings - Other values#
Node management#
Node management interfaces#
Configuring routing thresholds#
Migration to commit scopes#
bdr_read_all_conflicts#
Column-level conflict functions#
Replication set management#
Replication set membership#
DDL replication filtering#
Testing and tuning commands#
Sequences#
Sequence functions#
KSUUID v2 functions#
KSUUID v1 functions#
Replicated large objects#
Large object interface#
AutoPartition in PGD#
Stream triggers reference#
Stream triggers manipulation interfaces#
Stream triggers row functions#
Stream triggers row variables#
Internal catalogs and views#
Internal system functions#
General internal functions#
Task manager functions#
:ref:``bdr.monitor_replslots_details_on_all_nodes` <bdr.monitor_replslots_details_on_all_nodes>`
Column-level conflict functions#
Column-level conflict functions#
bdr_read_all_conflicts#
- User visible catalogs and views
- bdr.camo_decision_journal
bdr.camo_decision_journalcolumns- bdr.commit_decisions
bdr.commit_decisionscolumns- bdr.commit_scopes
bdr.commit_scopescolumns- bdr.conflict_history
bdr.conflict_historycolumns- bdr.conflict_history_summary
bdr.conflict_history_summarycolumns- bdr.consensus_kv_data
bdr.consensus_kv_dataColumns- bdr.crdt_handlers
bdr.crdt_handlersColumns- bdr.ddl_replication
bdr.ddl_replicationcolumns- bdr.depend
- bdr.failover_replication_slots
bdr.failover_replication_slotscolumns- bdr.global_consensus_journal
bdr.global_consensus_journalcolumns- bdr.global_consensus_journal_details
bdr.global_consensus_journal_detailscolumns- bdr.global_consensus_response_journal
bdr.global_consensus_response_journalcolumns- bdr.global_lock
bdr.global_lockcolumns- bdr.global_locks
bdr.global_lockscolumns- bdr.group_camo_details
bdr.group_camo_detailscolumns- bdr.group_lease
bdr.group_leasecolumns- bdr.group_raft_details
bdr.group_raft_detailscolumns- bdr.group_replslots_details
bdr.group_replslots_detailscolumns- bdr.group_subscription_summary
bdr.group_subscription_summarycolumns- bdr.group_versions_details
bdr.group_versions_detailscolumns- bdr.leader
bdr.leadercolumns- bdr.local_consensus_snapshot
bdr.local_consensus_snapshotcolumns- bdr.local_consensus_state
bdr.local_consensus_statecolumns- bdr.local_node
bdr.local_nodecolumns- bdr.local_node_summary
- bdr.local_sync_status
bdr.local_sync_statuscolumns- bdr.node
bdr.nodecolumns- bdr.node_catchup_info
bdr.node_catchup_infocolumns- bdr.node_catchup_info_details
- bdr.node_conflict_resolvers
bdr.node_conflict_resolverscolumns- bdr.node_group
bdr.node_groupcolumns- bdr.node_group_replication_sets
bdr.node_group_replication_setscolumns- bdr.node_group_summary
bdr.node_group_summarycolumns- bdr.node_local_info
bdr.node_local_infocolumns- bdr.node_log_config
bdr.node_log_configcolumns- bdr.node_peer_progress
bdr.node_peer_progresscolumns- bdr.node_replication_rates
bdr.node_replication_ratescolumns- bdr.node_slots
bdr.node_slotscolumns- bdr.node_summary
bdr.node_summarycolumns- bdr.parted_origin_catchup_info
bdr.parted_origin_catchup_infocolumns- bdr.parted_origin_catchup_info_details
bdr.parted_origin_catchup_info_detailscolumns- bdr.pending_failed_changes
bdr.pending_failed_changescolumns- bdr.pending_failed_changes_sql
bdr.pending_failed_changes_sqlcolumns- bdr.pgd_largeobject
bdr.pgd_largeobjectcolumns- bdr.pgd_largeobject_metadata
bdr.pgd_largeobject_metadatacolumns- bdr.queue
bdr.queuecolumns- bdr.replication_set
bdr.replication_setcolumns- bdr.replication_set_table
bdr.replication_set_tablecolumns- bdr.replication_set_ddl
bdr.replication_set_ddlColumns- bdr.replication_sets
bdr.replication_setscolumns- bdr.resolved_transactions
bdr.resolved_transactionscolumns- bdr.resolved_transactions_info
bdr.resolved_transactions_infocolumns- bdr.schema_changes
bdr.schema_changescolumns- bdr.sequence_alloc
bdr.sequence_alloccolumns- bdr.sequences
bdr.sequencescolumns- bdr.stat_activity
bdr.stat_activitycolumns- bdr.stat_commit_scope
bdr.stat_commit_scopecolumns- bdr.stat_commit_scope_state
bdr.stat_commit_scope_statecolumns- bdr.stat_connection_manager
bdr.stat_connection_managercolumns- bdr.stat_connection_manager_connections
bdr.stat_connection_manager_connectionscolumns- bdr.stat_connection_manager_node_stats
bdr.stat_connection_manager_node_statscolumns- bdr.stat_connection_manager_hba_file_rules
bdr.stat_connection_manager_hba_file_rulescolumns- bdr.stat_raft_followers_state
bdr.stat_raft_followers_statecolumns- bdr.stat_raft_state
bdr.stat_raft_statecolumns- bdr.stat_receiver
bdr.stat_receivercolumns- bdr.stat_receiver_transactions
bdr.stat_receiver_transactionscolumns- bdr.stat_reconcile_commit_scope
bdr.stat_reconcile_commit_scopecolumns- bdr.stat_relation
bdr.stat_relationcolumns- bdr.stat_routing_candidate_state
bdr.stat_routing_candidate_statecolumns- bdr.stat_routing_state
bdr.stat_routing_statecolumns- bdr.stat_subscription
bdr.stat_subscriptioncolumns- bdr.stat_worker
bdr.stat_workercolumns- bdr.stat_writer
bdr.stat_writercolumns- bdr.subscription
bdr.subscriptioncolumns- bdr.subscription_summary
bdr.subscription_summarycolumns- bdr.subscription_error_status
bdr.subscription_error_statuscolumns- bdr.tables
bdr.tablescolumns- bdr.taskmgr_work_queue
bdr.taskmgr_work_queuecolumns- bdr.taskmgr_workitem_status
bdr.taskmgr_workitem_statuscolumns- bdr.taskmgr_local_work_queue
bdr.taskmgr_local_work_queuecolumns- bdr.taskmgr_local_workitem_status
bdr.taskmgr_local_workitem_statuscolumns- bdr.trigger
bdr.triggercolumns- bdr.triggers
- bdr.workers
bdr.workersColumns- bdr.writers
bdr.writerscolumns- bdr.worker_tasks
bdr.worker_taskscolumns
- System functions
- Version information functions
- System information functions
- System and progress information parameters
- Node status functions
- Consensus function
- Utility functions
- bdr.transfer_all_leaderships
- Synopsis
- Parameters
- Return value
- bdr.alter_node_kind
- Synopsis
- Parameters
- bdr.alter_subscription_skip_changes_upto
- Synopsis
- Example
- bdr.connection_manager_refresh_pools
- Synopsis
- bdr.get_node_sub_apply_lsn
- Synopsis
- Parameters
- bdr.get_node_sub_receive_lsn
- Synopsis
- Parameters
- bdr.global_lock_table
- Synopsis
- Parameters
- Notes
- Example
- bdr.group_lease_override
- Parameters
- bdr.local_group_slot_name
- bdr.node_group_type
- Example
- bdr.replicate_ddl_command
- Synopsis
- Parameters
- Notes
- bdr.run_on_all_nodes
- Synopsis
- Parameters
- Notes
- Example
- bdr.run_on_group
- Synopsis
- Parameters
- Notes
- bdr.run_on_nodes
- Synopsis
- Parameters
- Notes
- bdr.stat_reset
- Parameters
- bdr.wait_for_apply_queue
- Synopsis
- Parameters
- bdr.wait_for_xid_progress
- Synopsis
- Parameters
- Notes
- bdr.wait_node_confirm_lsn
- Synopsis
- Parameters
- Notes
- bdr.wait_slot_confirm_lsn
- Synopsis
- Notes
- Parameters
- Global advisory locks
- Monitoring functions
- bdr.monitor_group_versions
- Synopsis
- Notes
- bdr.monitor_group_raft
- Synopsis
- Parameters
- Notes
- bdr.monitor_local_replslots
- Synopsis
- Notes
- bdr.ts_metrics
- Synopsis
- Output columns
- Notes
- bdr.ts_latest
- Synopsis
- Parameters
- Output columns
- Notes
- bdr.ts_errors
- Synopsis
- Parameters
- Output columns
- Notes
- bdr.ts_samples
- Synopsis
- Parameters
- Output columns
- Notes
- bdr.ts_histogram
- Synopsis
- Parameters
- Output columns
- Notes
- bdr.ts_histogram_distribution
- Synopsis
- Parameters
- Output columns
- Notes
- bdr.ts_histogram_cumulative
- Synopsis
- Parameters
- Output columns
- Notes
- bdr.wal_sender_stats
- Synopsis
- Output columns
- bdr.get_decoding_worker_stat
- Synopsis
- Output columns
- Notes
- bdr.lag_control
- Synopsis
- Output columns
- Routing functions
- CAMO functions
- Commit Scope functions
- Apply error policy functions
- bdr.skip_failed_change
- Synopsis
- Parameters
- bdr.skip_failed_transaction
- Synopsis
- Parameters
- Return value
- bdr.apply_failed_change
- Synopsis
- Parameters
- bdr.apply_failed_transaction
- Synopsis
- Parameters
- Return value
- bdr.modify_failed_change
- Synopsis
- Parameters
- bdr.reconstruct_change_sql
- Synopsis
- Parameters
- Return value
- bdr.reconstruct_failed_transaction
- Synopsis
- Parameters
- Return value
- bdr.resolve_failed_transaction
- Synopsis
- Parameters
- Return value
- Notes
- bdr.analyze_skip_impact
- Synopsis
- Parameters
- Return value
- Safety classifications
- bdr.analyze_transaction_skip_impact
- Synopsis
- Parameters
- Return value
- bdr.format_skip_analysis
- Synopsis
- Parameters
- Return value
- bdr.alter_subscription_reset_error_counters
- Synopsis
- Parameters
- Monitoring metrics reference
- PGD settings
- Conflict handling
- Global sequence parameters
- DDL handling
- Global locking
- Node management
- Generic replication
- CRDTs
- Large objects
- Commit scope
- Commit At Most Once
- Transaction streaming
- Lag Control
- Monitoring and logging
- Decoding worker
- Connectivity settings
- Connection Manager
- Topology settings
- Analytics settings
- Internal settings - Raft timeouts
- Internal settings - Other Raft values
- Internal settings - Other values
- Node management
- Node management interfaces
- bdr.alter_node_group_option
- bdr.alter_node_interface
- bdr.alter_node_option
- bdr.alter_subscription_enable
- bdr.alter_subscription_disable
- bdr.create_node
- bdr.create_node_group
- bdr.drop_node_group
- bdr.join_node_group
- bdr.part_node
- bdr.promote_node
- bdr.switch_node_group
- bdr.sync_node_cancel
- bdr.wait_for_join_completion
- Routing functions
- Commit scopes
- Conflicts
- Conflict functions
- Replication set management
- Replication set membership
- DDL replication filtering
- Testing and tuning commands
- Global sequence management interfaces
- Sequence functions
- bdr.alter_sequence_set_kind
- Synopsis
- Parameters
- Notes
- bdr.extract_timestamp_from_snowflakeid
- Synopsis
- Parameters
- Notes
- bdr.extract_nodeid_from_snowflakeid
- Synopsis
- Parameters
- Notes
- bdr.extract_localseqid_from_snowflakeid
- Synopsis
- Parameters
- Notes
- bdr.timestamp_to_snowflakeid
- Synopsis
- Parameters
- Notes
- bdr.extract_timestamp_from_timeshard
- Synopsis
- Parameters
- Notes
- bdr.extract_nodeid_from_timeshard
- Synopsis
- Parameters
- Notes
- bdr.extract_localseqid_from_timeshard
- Synopsis
- Parameters
- Notes
- bdr.timestamp_to_timeshard
- Synopsis
- Parameters
- Notes
- bdr.galloc_chunk_info
- Synopsis
- Parameters
- Notes
- KSUUID v2 functions
- KSUUID v1 functions
- Sequence functions
- Large object functions
- Large object interface
- bdr.lo_creat
- Synopsis
- Parameters
- bdr.lo_create
- Synopsis
- Parameters
- bdr.lo_open
- Synopsis
- Parameters
- bdr.lo_close
- Synopsis
- Parameters
- bdr.loread
- Synopsis
- Parameters
- bdr.lowrite
- Synopsis
- Parameters
- bdr.lo_lseek
- Synopsis
- Parameters
- bdr.lo_lseek64
- Synopsis
- Parameters
- bdr.lo_tell
- Synopsis
- Parameters
- bdr.lo_tell64
- Synopsis
- Parameters
- bdr.lo_truncate
- Synopsis
- Parameters
- bdr.lo_truncate64
- Synopsis
- Parameters
- bdr.lo_unlink
- Synopsis
- Parameters
- bdr.lo_import
- Synopsis
- Parameters
- bdr.lo_import_with_oid
- Synopsis
- Parameters
- bdr.lo_export
- Synopsis
- Parameters
- bdr.lo_get
- Synopsis
- Parameters
- bdr.lo_get_fragment
- Synopsis
- Parameters
- bdr.lo_from_bytea
- Synopsis
- Parameters
- bdr.lo_put
- Synopsis
- Parameters
- Large object interface
- Autopartition
- bdr.autopartition
- Synopsis
- Parameters
- Examples
- bdr.drop_autopartition
- Parameters
- bdr.autopartition_wait_for_partitions
- Synopsis
- Parameters
- bdr.autopartition_wait_for_partitions_on_all_nodes
- Synopsis
- Parameters
- bdr.autopartition_find_partition
- Synopsis
- Parameters
- bdr.autopartition_enable
- Synopsis
- Parameters
- bdr.autopartition_disable
- Synopsis
- Parameters
- Internal functions
- bdr.autopartition_create_partition
- Synopsis
- Parameters
- Notes
- bdr.autopartition_drop_partition
- Synopsis
- Parameters
- Notes
- Stream triggers reference
- Internal catalogs and views
- bdr.autopartition_partitions
bdr.autopartition_partitionscolumns- bdr.autopartition_rules
bdr.autopartition_rulescolumns- bdr.ddl_epoch
bdr.ddl_epochcolumns- bdr.event_history
bdr.event_historycolumns- bdr.event_summary
- bdr.leader_tenure_backlog
bdr.leader_tenure_backlogcolumns- bdr.local_leader_change
- bdr.node_config
bdr.node_configcolumns- bdr.node_config_summary
bdr.node_config_summarycolumns- bdr.node_group_config
bdr.node_group_configcolumns- bdr.node_group_routing_config_summary
bdr.node_group_routing_config_summarycolumns- bdr.node_group_routing_info
bdr.node_group_routing_infocolumns- bdr.node_group_routing_summary
bdr.node_group_routing_summarycolumns- bdr.node_peer_progress_mapping
bdr.node_peer_progress_mappingcolumns- bdr.node_routing_config_summary
bdr.node_routing_config_summarycolumns- bdr.prepared_xacts_summary
bdr.prepared_xacts_summarycolumns- bdr.reconcile_2pc_requests
bdr.reconcile_2pc_requestscolumns- bdr.reconcile_2pc_requests_summary
bdr.reconcile_2pc_requests_summarycolumns- bdr.sequence_kind
bdr.sequence_kindcolumns- bdr.sync_node_requests
bdr.sync_node_requestscolumns- bdr.sync_node_requests_summary
bdr.sync_node_requests_summarycolumns
- Internal system functions
- General internal functions
- bdr.bdr_get_commit_decisions
- Synopsis
- bdr.bdr_track_commit_decision
- Synopsis
- bdr.consensus_kv_fetch
- Synopsis
- Parameters
- Notes
- bdr.consensus_kv_store
- Synopsis
- Parameters
- Notes
- bdr.decode_message_payload
- bdr.decode_message_response_payload
- bdr.difference_fix_origin_create
- bdr.difference_fix_session_reset
- Synopsis
- bdr.difference_fix_session_setup
- Synopsis
- bdr.difference_fix_xact_set_avoid_conflict
- Synopsis
- bdr.drop_node
- Parameters
- Notes
- bdr.get_global_locks
- bdr.get_node_conflict_resolvers
- bdr.get_slot_flush_timestamp
- bdr.internal_alter_sequence_set_kind
- bdr.internal_replication_set_add_table
- bdr.internal_replication_set_remove_table
- bdr.internal_submit_join_request
- bdr.isolation_test_session_is_blocked
- bdr.local_node_info
- bdr.msgb_connect
- bdr.msgb_deliver_message
- bdr.node_catchup_state_name
- Synopsis
- Parameters
- bdr.node_kind_name
- bdr.peer_state_name
- bdr.pg_xact_origin
- Synopsis
- Parameters
- bdr.reconcile_2pc_status_name
- Synopsis
- Parameters
- bdr.request_replay_progress_update
- bdr.reset_relation_stats
- bdr.reset_subscription_stats
- bdr.resynchronize_table_from_node
- Synopsis
- Parameters
- Notes
- bdr.seq_currval
- bdr.seq_lastval
- bdr.seq_nextval
- bdr.show_subscription_status
- bdr.show_workers
- Synopsis
- bdr.show_writers
- bdr.sync_status_name
- Synopsis
- Parameters
- Task manager functions
- bdr.taskmgr_set_leader
- Synopsis
- bdr.taskmgr_get_last_completed_workitem
- Synopsis
- bdr.taskmgr_work_queue_check_status
- Synopsis
- Parameters
- Notes
- bdr.get_min_required_replication_slots
- bdr.get_min_required_active_replication_origins
- bdr.get_min_required_worker_processes
- bdr.stat_last_reset_time
- bdr.stat_get_activity
- bdr.stat_get_commit_scope
- bdr.stat_get_commit_scope_proc_wait
- bdr.stat_get_reconcile_commit_scope
- bdr.worker_role_id_name
- bdr.lag_history
- bdr.get_raft_instance_by_nodegroup
- bdr.monitor_camo_on_all_nodes
- bdr.monitor_raft_details_on_all_nodes
bdr.monitor_replslots_details_on_all_nodes- bdr.monitor_subscription_details_on_all_nodes
- bdr.monitor_version_details_on_all_nodes
- bdr.node_group_member_info
- General internal functions
- Column-level conflict functions