Internal catalogs and views v5.6
Catalogs and views are listed here in alphabetical order.
bdr.autopartition_partitions
An internal catalog table that stores information about the partitions created by the autopartitioning feature.
bdr.autopartition_partitions columns
| Name | Type | Description |
|---|---|---|
| ap_parent_relid | oid | OID for relation |
| ap_part_relname | name | Name of created relation |
| ap_part_created_at | timestamp with time zone | Creation timestamp |
| ap_part_migrated_at | timestamp with time zone | Migration timestamp |
| ap_part_dropped_at | timestamp with time zone | Timestamp when dropped |
bdr.autopartition_rules
An internal catalog table that stores information about the autopartitioning rules.
bdr.autopartition_rules columns
| Name | Type | Description |
|---|---|---|
| ap_partition_relid | oid | |
| ap_partition_relname | name | |
| ap_partition_schemaname | name | |
| ap_partition_increment_kind | "char" | |
| ap_secondary_tablespace | oid | |
| ap_maximum_advance_partitions | integer | |
| ap_is_autoscaled | boolean | |
| ap_latest_partitions | integer | |
| ap_enabled | boolean | |
| ap_migrate_after_period | interval | |
| ap_data_retention_period | interval | |
| ap_last_triggered | timestamp with time zone | |
| ap_partition_increment_value | text | |
| ap_partition_autocreate_expr | text | |
| ap_partition_initial_lowerbound | text | |
| ap_partition_last_upperbound | text | |
| ap_is_local | boolean | |
| ap_partition_min_upperbound | text |
bdr.ddl_epoch
An internal catalog table holding state per DDL epoch.
bdr.ddl_epoch columns
| Name | Type | Description |
|---|---|---|
| ddl_epoch | int8 | Monotonically increasing epoch number |
| origin_node_id | oid | Internal node ID of the node that requested creation of this epoch |
| epoch_consume_timeout | timestamptz | Timeout of this epoch |
| epoch_consumed | boolean | Switches to true as soon as the local node has fully processed the epoch |
| epoch_consumed_lsn | boolean | LSN at which the local node has processed the epoch |
bdr.event_history
Internal catalog table that tracks cluster membership events for a given PGD node. Specifically, it tracks:
- Node joins (to the cluster)
- Raft state changes (that is, whenever the node changes its role in the consensus protocol - leader, follower, or candidate to leader); see Monitoring Raft consensus
- Whenever a worker has errored out (see bdr.workers and Monitoring PGD replication workers)
bdr.event_history columns
| Name | Type | Description |
|---|---|---|
| event_node_id | oid | ID of the node to which the event refers |
| event_type | int | Type of the event (a node, raft, or worker-related event) |
| event_sub_type | int | Subtype of the event, that is, if it's a join, a state change, or an error |
| event_source | text | Name of the worker process where the event was sourced |
| event_time | timestamptz | Timestamp at which the event occurred |
| event_text | text | Textual representation of the event (for example, the error of the worker) |
| event_detail | text | A more detailed description of the event (for now, only relevant for worker errors) |
bdr.event_summary
A view of the bdr.event_history catalog that displays the information in a more
human-friendly format. Specifically, it displays the event types and subtypes
as textual representations rather than integers.
bdr.local_leader_change
This is a local cache of the recent portion of leader change history. It has the same fields as bdr.leader, except that it is an ordered set of (node_group_id, leader_kind, generation) instead of a map tracking merely the current version.
bdr.node_config
An internal catalog table with per-node configuration options.
bdr.node_config columns
| Name | Type | Description |
|---|---|---|
| node_id | oid | Node ID |
| node_route_priority | int | Priority assigned to this node |
| node_route_fence | boolean | Switch to fence this node |
| node_route_writes | boolean | Switch to allow writes |
| node_route_reads | boolean | Switch to allow reads |
| node_route_dsn | text | Interface of this node |
bdr.node_config_summary
A view of the bdr.node_config catalog that displays the information in a more human-readable format.
bdr.node_config_summary columns
| Name | Type | Description |
|---|---|---|
| node_name | text | The name of this node |
| node_id | oid | Node ID |
| node_route_priority | int | Priority assigned to this node |
| node_route_fence | boolean | Switch to fence this node |
| node_route_writes | boolean | Switch to allow writes |
| node_route_reads | boolean | Switch to allow reads |
| node_route_dsn | text | Interface of this node |
| effective_route_dsn | text | Full DSN of this node |
bdr.node_group_config
An internal catalog table with per-node group configuration options.
bdr.node_group_config columns
| Name | Type | Description |
|---|---|---|
| node_group_id | oid | Node group ID |
| route_writer_max_lag | bigint | Maximum write lag accepted |
| route_reader_max_lag | bigint | Maximum read lag accepted |
| route_writer_wait_flush | boolean | Switch if we need to wait for the flush |
bdr.node_group_routing_config_summary
Per-node-group routing configuration options.
bdr.node_group_routing_config_summary columns
| Name | Type | Description |
|---|---|---|
| node_group_name | name | Node group name |
| location | name | Node group location |
| enable_proxy_routing | boolean | Group proxy routing enabled? |
| node_group_type | text | Node group type (one of "global", "data", or "subscriber-only") |
| route_writer_max_lag | bigint | Maximum write lag accepted |
| route_reader_max_lag | bigint | Maximum read lag accepted |
| route_writer_wait_flush | boolean | Wait for flush |
bdr.node_group_routing_info
An internal catalog table holding current routing information for a proxy.
bdr.node_group_routing_info columns
| Name | Type | Description |
|---|---|---|
| node_group_id | oid | Node group ID. |
| write_node_id | oid | Current write node. |
| prev_write_node_id | oid | Previous write node. |
| read_node_ids | oid[] | List of read-only nodes IDs. |
| record_version | bigint | Record version. Incremented by 1 on every material change to the routing record. |
| record_ts | timestamptz | Timestamp of last update to record_version. |
| write_leader_version | bigint | Write leader version. Copied from record_version every time write_node_id is changed. |
| write_leader_ts | timestamptz | Write leader timestamp. Copied from record_ts every time write_node_id is changed. |
| read_nodes_version | bigint | Read nodes version. Copied from record_version every time read_node_ids list is changed. |
| read_nodes_ts | timestamptz | Read nodes timestamp. Copied from record_tw every time read_node_ids list is changed. |
bdr.node_group_routing_summary
A view of bdr.node_group_routing_info catalog that shows the information in more friendly way.
bdr.node_group_routing_summary columns
| Name | Type | Description |
|---|---|---|
| node_group_name | name | Node group name |
| write_lead | name | Current write lead |
| previous_write_lead | name | Previous write lead |
| read_nodes | name[] | Current read-only nodes |
bdr.node_routing_config_summary
A friendly view of the per-node routing configuration options. Shows the node name rather than the oid and shorter field names.
bdr.node_routing_config_summary columns
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name |
| route_priority | int | Priority assigned to this node |
| route_fence | boolean | Switch to fence this node |
| route_writes | boolean | Switch to allow writes |
| route_reads | boolean | Switch to allow reads |
| route_dsn | text | Interface of this node |
bdr.proxy_config
An internal catalog table holding proxy specific configurations.
bdr.proxy_config columns
| Name | Type | Description |
|---|---|---|
| proxy_name | name | Name of the proxy |
| node_group_id | oid | Node group ID that this proxy uses |
| listen_port | int | Port that the proxy uses for read-write connections (setting to 0 disables port) |
| max_client_conn | int | Number of maximum read-write client connections that the proxy accepts |
| max_server_conn | int | Number of maximum read-write connections that the server accepts |
| server_conn_timeout | interval | Timeout for the read-write server connections |
| server_conn_keepalive | interval | Interval between the server connection keep-alive |
| fallback_group_timeout | interval | Timeout needed for the fallback |
| fallback_group_ids | oid[] | List of group IDs to use for the fallback |
| listen_addrs | text[] | Listen address |
| read_listen_port | int | Port that the proxy uses for read-only connections (setting to 0 disables port) |
| read_max_client_conn | int | Number of maximum read-only client connections that the proxy accepts |
| read_max_server_conn | int | Number of maximum read-only connections that the server accepts |
| read_server_conn_timeout | interval | Timeout for the server read-only connections |
| read_server_conn_keepalive | interval | Interval between the server read-only connection keep-alive |
| read_listen_addrs | text[] | Listen address for read-only connections |
| read_consensus_grace_period | interval | Duration for which proxy continues to route even upon loss of consensus |
bdr.proxy_config_summary
A friendly view of per-proxy, instance-specific configuration options.
bdr.proxy_config_summary columns
| Name | Type | Description |
|---|---|---|
| proxy_name | name | Name of the proxy |
| node_group_name | name | Node group name that this proxy uses |
| listen_port | int | Port that the proxy uses for read-write connections (setting to -1 disables port) |
| max_client_conn | int | Number of maximum read-write client connections that the proxy accepts |
| max_server_conn | int | Number of maximum read-write connections that the server accepts |
| server_conn_timeout | interval | Timeout for the read-write server connections |
| server_conn_keepalive | interval | Interval between the server connection keep-alive |
| node_group_enable_proxy_routing | boolean | Does the group the proxy is in enable proxy routing? |
| node_group_location | name | The group's location value |
| fallback_group_timeout | interval | Timeout needed for the fallback |
| fallback_group_ids | oid[] | List of group IDs to use for the fallback |
| listen_addrs | text[] | Listen address |
| read_listen_port | int | Port that the proxy uses for read-only connections (setting to -1 disables port) |
| read_max_client_conn | int | Number of maximum read-only client connections that the proxy accepts |
| read_max_server_conn | int | Number of maximum read-only connections that the server accepts |
| read_server_conn_timeout | interval | Timeout for the server read-only connections |
| read_server_conn_keepalive | interval | Interval between the server read-only connection keep-alive |
| read_listen_addrs | text[] | Listen address for read-only connections |
| read_consensus_grace_period | interval | Duration for which proxy continues to route even upon loss of consensus |
bdr.sequence_kind
An internal state table storing the type of each non-local sequence. We recommend the view
bdr.sequences for diagnostic purposes.
bdr.sequence_kind columns
| Name | Type | Description |
|---|---|---|
| seqid | oid | Internal OID of the sequence |
| seqkind | char | Internal sequence kind (l=local,t=timeshard,s=snowflakeid,g=galloc) |
- On this page
- bdr.autopartition_partitions
- bdr.autopartition_rules
- bdr.ddl_epoch
- bdr.event_history
- bdr.event_summary
- bdr.local_leader_change
- bdr.node_config
- bdr.node_config_summary
- bdr.node_group_config
- bdr.node_group_routing_config_summary
- bdr.node_group_routing_info
- bdr.node_group_routing_summary
- bdr.node_routing_config_summary
- bdr.proxy_config
- bdr.proxy_config_summary
- bdr.sequence_kind