SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 15 → 16
1 added · 0 removed · 22 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedpg_attribute
--- 15 +++ 16 @@ -1,12 +1,11 @@ attrelid oid attname name atttypid oid -attstattarget int4 attlen int2 attnum int2 -attndims int4 attcacheoff int4 atttypmod int4 +attndims int2 attbyval bool attalign char attstorage char @@ -18,7 +17,8 @@ attgenerated char attisdropped bool attislocal bool -attinhcount int4 +attinhcount int2 +attstattarget int2 attcollation oid attacl aclitem[] attoptions text[]
changedpg_auth_members
--- 15 +++ 16 @@ -1,4 +1,7 @@ +oid oid roleid oid member oid grantor oid admin_option bool +inherit_option bool +set_option bool
changedpg_collation
--- 15 +++ 16 @@ -8,4 +8,5 @@ collcollate text collctype text colliculocale text +collicurules text collversion text
changedpg_constraint
--- 15 +++ 16 @@ -14,7 +14,7 @@ confdeltype char confmatchtype char conislocal bool -coninhcount int4 +coninhcount int2 connoinherit bool conkey int2[] confkey int2[]
changedpg_database
--- 15 +++ 16 @@ -12,5 +12,6 @@ datcollate text datctype text daticulocale text +daticurules text datcollversion text datacl aclitem[]
changedpg_hba_file_rules
--- 15 +++ 16 @@ -1,3 +1,5 @@ +rule_number int4 +file_name text line_number int4 type text database text[]
changedpg_ident_file_mappings
--- 15 +++ 16 @@ -1,3 +1,5 @@ +map_number int4 +file_name text line_number int4 map_name text sys_name text
changedpg_prepared_statements
--- 15 +++ 16 @@ -2,6 +2,7 @@ statement text prepare_time timestamptz parameter_types regtype[] +result_types regtype[] from_sql bool generic_plans int8 custom_plans int8
changedpg_replication_slots
--- 15 +++ 16 @@ -13,3 +13,4 @@ wal_status text safe_wal_size int8 two_phase bool +conflicting bool
changedpg_stat_all_indexes
--- 15 +++ 16 @@ -4,5 +4,6 @@ relname name indexrelname name idx_scan bigint +last_idx_scan timestamp with time zone idx_tup_read bigint idx_tup_fetch bigint
changedpg_stat_all_tables
--- 15 +++ 16 @@ -2,13 +2,16 @@ schemaname name relname name seq_scan bigint +last_seq_scan timestamp with time zone seq_tup_read bigint idx_scan bigint +last_idx_scan timestamp with time zone 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 n_live_tup bigint n_dead_tup bigint n_mod_since_analyze bigint
changedpg_stat_database_conflicts
--- 15 +++ 16 @@ -5,3 +5,4 @@ confl_snapshot bigint confl_bufferpin bigint confl_deadlock bigint +confl_active_logicalslot bigint
changedpg_stat_gssapi
--- 15 +++ 16 @@ -2,3 +2,4 @@ gss_authenticated boolean principal text encrypted boolean +credentials_delegated boolean
addedpg_stat_io
--- 15 +++ 16 @@ -0,0 +1,18 @@ +backend_type text +object text +context text +reads bigint +read_time double precision +writes bigint +write_time double precision +writebacks bigint +writeback_time double precision +extends bigint +extend_time double precision +op_bytes bigint +hits bigint +evictions bigint +reuses bigint +fsyncs bigint +fsync_time double precision +stats_reset timestamp with time zone
changedpg_stat_subscription
--- 15 +++ 16 @@ -1,6 +1,7 @@ subid oid subname name pid integer +leader_pid integer relid oid received_lsn pg_lsn last_msg_send_time timestamp with time zone
changedpg_stat_sys_indexes
--- 15 +++ 16 @@ -4,5 +4,6 @@ relname name indexrelname name idx_scan bigint +last_idx_scan timestamp with time zone idx_tup_read bigint idx_tup_fetch bigint
changedpg_stat_sys_tables
--- 15 +++ 16 @@ -2,13 +2,16 @@ schemaname name relname name seq_scan bigint +last_seq_scan timestamp with time zone seq_tup_read bigint idx_scan bigint +last_idx_scan timestamp with time zone 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 n_live_tup bigint n_dead_tup bigint n_mod_since_analyze bigint
changedpg_stat_user_indexes
--- 15 +++ 16 @@ -4,5 +4,6 @@ relname name indexrelname name idx_scan bigint +last_idx_scan timestamp with time zone idx_tup_read bigint idx_tup_fetch bigint
changedpg_stat_user_tables
--- 15 +++ 16 @@ -2,13 +2,16 @@ schemaname name relname name seq_scan bigint +last_seq_scan timestamp with time zone seq_tup_read bigint idx_scan bigint +last_idx_scan timestamp with time zone 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 n_live_tup bigint n_dead_tup bigint n_mod_since_analyze bigint
changedpg_stat_xact_all_tables
--- 15 +++ 16 @@ -9,3 +9,4 @@ n_tup_upd bigint n_tup_del bigint n_tup_hot_upd bigint +n_tup_newpage_upd bigint
changedpg_stat_xact_sys_tables
--- 15 +++ 16 @@ -9,3 +9,4 @@ n_tup_upd bigint n_tup_del bigint n_tup_hot_upd bigint +n_tup_newpage_upd bigint
changedpg_stat_xact_user_tables
--- 15 +++ 16 @@ -9,3 +9,4 @@ n_tup_upd bigint n_tup_del bigint n_tup_hot_upd bigint +n_tup_newpage_upd bigint
changedpg_subscription
--- 15 +++ 16 @@ -5,10 +5,13 @@ subowner oid subenabled bool subbinary bool -substream bool +substream char subtwophasestate char subdisableonerr bool +subpasswordrequired bool +subrunasowner bool subconninfo text subslotname name subsynccommit text subpublications text[] +suborigin text