Internal catalogs and views#
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
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) |