What changed?

System Catalogs · PostgreSQL 19 beta 3 → 20 devel

Development snapshot. These definitions may change before release.

1 added · 7 removed · 1 changed · 4 coverage changes. These are changes in the pinned reference snapshots.

--- 19 beta 3
+++ 20 devel
@@ -1,14 +0,0 @@
-oid  oid
-pgepgid  oid
-pgerelid  oid
-pgealias  name
-pgekind  char
-pgesrcvertexid  oid
-pgedestvertexid  oid
-pgekey  int2[]
-pgesrckey  int2[]
-pgesrcref  int2[]
-pgesrceqop  oid[]
-pgedestkey  int2[]
-pgedestref  int2[]
-pgedesteqop  oid[]

removedpg_propgraph_element_label

--- 19 beta 3
+++ 20 devel
@@ -1,3 +0,0 @@
-oid  oid
-pgellabelid  oid
-pgelelid  oid

removedpg_propgraph_label

--- 19 beta 3
+++ 20 devel
@@ -1,3 +0,0 @@
-oid  oid
-pglpgid  oid
-pgllabel  name

removedpg_propgraph_label_property

--- 19 beta 3
+++ 20 devel
@@ -1,4 +0,0 @@
-oid  oid
-plppropid  oid
-plpellabelid  oid
-plpexpr  pg_node_tree

removedpg_propgraph_property

--- 19 beta 3
+++ 20 devel
@@ -1,6 +0,0 @@
-oid  oid
-pgppgid  oid
-pgpname  name
-pgptypid  oid
-pgptypmod  int4
-pgpcollation  oid

addedpg_stat_kind_info

--- 19 beta 3
+++ 20 devel
@@ -0,0 +1,7 @@
+id  integer
+name  text
+builtin  boolean
+fixed_amount  boolean
+accessed_across_databases  boolean
+write_to_file  boolean
+entry_count  bigint

coveragepg_stat_xact_all_tables

--- 19 beta 3
+++ 20 devel
@@ -1,12 +0,0 @@
-relid  oid
-schemaname  name
-relname  name
-seq_scan  bigint
-seq_tup_read  bigint
-idx_scan  bigint
-idx_tup_fetch  bigint
-n_tup_ins  bigint
-n_tup_upd  bigint
-n_tup_del  bigint
-n_tup_hot_upd  bigint
-n_tup_newpage_upd  bigint

coveragepg_stat_xact_sys_tables

--- 19 beta 3
+++ 20 devel
@@ -1,12 +0,0 @@
-relid  oid
-schemaname  name
-relname  name
-seq_scan  bigint
-seq_tup_read  bigint
-idx_scan  bigint
-idx_tup_fetch  bigint
-n_tup_ins  bigint
-n_tup_upd  bigint
-n_tup_del  bigint
-n_tup_hot_upd  bigint
-n_tup_newpage_upd  bigint

coveragepg_stat_xact_user_functions

--- 19 beta 3
+++ 20 devel
@@ -1,6 +0,0 @@
-funcid  oid
-schemaname  name
-funcname  name
-calls  bigint
-total_time  double precision
-self_time  double precision

coveragepg_stat_xact_user_tables

--- 19 beta 3
+++ 20 devel
@@ -1,12 +0,0 @@
-relid  oid
-schemaname  name
-relname  name
-seq_scan  bigint
-seq_tup_read  bigint
-idx_scan  bigint
-idx_tup_fetch  bigint
-n_tup_ins  bigint
-n_tup_upd  bigint
-n_tup_del  bigint
-n_tup_hot_upd  bigint
-n_tup_newpage_upd  bigint

removedpg_statio_sys_sequences

--- 19 beta 3
+++ 20 devel
@@ -1,6 +0,0 @@
-relid  oid
-schemaname  name
-relname  name
-blks_read  bigint
-blks_hit  bigint
-stats_reset  timestamp with time zone

removedpg_statio_user_sequences

--- 19 beta 3
+++ 20 devel
@@ -1,6 +0,0 @@
-relid  oid
-schemaname  name
-relname  name
-blks_read  bigint
-blks_hit  bigint
-stats_reset  timestamp with time zone

changedpg_statistic

--- 19 beta 3
+++ 20 devel
@@ -4,28 +4,8 @@
 stanullfrac  float4
 stawidth  int4
 stadistinct  float4
-stakind1  int2
-stakind2  int2
-stakind3  int2
-stakind4  int2
-stakind5  int2
-staop1  oid
-staop2  oid
-staop3  oid
-staop4  oid
-staop5  oid
-stacoll1  oid
-stacoll2  oid
-stacoll3  oid
-stacoll4  oid
-stacoll5  oid
-stanumbers1  float4[]
-stanumbers2  float4[]
-stanumbers3  float4[]
-stanumbers4  float4[]
-stanumbers5  float4[]
-stavalues1  anyarray
-stavalues2  anyarray
-stavalues3  anyarray
-stavalues4  anyarray
-stavalues5  anyarray
+stakindN  int2
+staopN  oid
+stacollN  oid
+stanumbersN  float4[]
+stavaluesN  anyarray