SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 13 → 14
5 added · 0 removed · 15 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedpg_attribute
--- 13 +++ 14 @@ -8,8 +8,9 @@ attcacheoff int4 atttypmod int4 attbyval bool +attalign char attstorage char -attalign char +attcompression char attnotnull bool atthasdef bool atthasmissing bool
addedpg_backend_memory_contexts
--- 13 +++ 14 @@ -0,0 +1,9 @@ +name text +ident text +parent text +level int4 +total_bytes int8 +total_nblocks int8 +free_bytes int8 +free_chunks int8 +used_bytes int8
changedpg_inherits
--- 13 +++ 14 @@ -1,3 +1,4 @@ inhrelid oid inhparent oid inhseqno int4 +inhdetachpending bool
changedpg_locks
--- 13 +++ 14 @@ -13,3 +13,4 @@ mode text granted bool fastpath bool +waitstart timestamptz
changedpg_prepared_statements
--- 13 +++ 14 @@ -3,3 +3,5 @@ prepare_time timestamptz parameter_types regtype[] from_sql bool +generic_plans int8 +custom_plans int8
changedpg_proc
--- 13 +++ 14 @@ -25,5 +25,6 @@ protrftypes oid[] prosrc text probin text +prosqlbody pg_node_tree proconfig text[] proacl aclitem[]
changedpg_range
--- 13 +++ 14 @@ -1,5 +1,6 @@ rngtypid oid rngsubtype oid +rngmultitypid oid rngcollation oid rngsubopc oid rngcanonical regproc
changedpg_replication_slots
--- 13 +++ 14 @@ -12,3 +12,4 @@ confirmed_flush_lsn pg_lsn wal_status text safe_wal_size int8 +two_phase bool
changedpg_stat_activity
--- 13 +++ 14 @@ -17,5 +17,6 @@ state text backend_xid xid backend_xmin xid +query_id bigint query text backend_type text
changedpg_stat_database
--- 13 +++ 14 @@ -18,4 +18,11 @@ checksum_last_failure timestamp with time zone blk_read_time double precision blk_write_time double precision +session_time double precision +active_time double precision +idle_in_transaction_time double precision +sessions bigint +sessions_abandoned bigint +sessions_fatal bigint +sessions_killed bigint stats_reset timestamp with time zone
addedpg_stat_progress_copy
--- 13 +++ 14 @@ -0,0 +1,10 @@ +pid integer +datid oid +datname name +relid oid +command text +type text +bytes_processed bigint +bytes_total bigint +tuples_processed bigint +tuples_excluded bigint
addedpg_stat_replication_slots
--- 13 +++ 14 @@ -0,0 +1,10 @@ +slot_name text +spill_txns bigint +spill_count bigint +spill_bytes bigint +stream_txns bigint +stream_count bigint +stream_bytes bigint +total_txns bigint +total_bytes bigint +stats_reset timestamp with time zone
changedpg_stat_ssl
--- 13 +++ 14 @@ -3,7 +3,6 @@ version text cipher text bits integer -compression boolean client_dn text client_serial numeric issuer_dn text
addedpg_stat_wal
--- 13 +++ 14 @@ -0,0 +1,9 @@ +wal_records bigint +wal_fpi bigint +wal_bytes numeric +wal_buffers_full bigint +wal_write bigint +wal_sync bigint +wal_write_time double precision +wal_sync_time double precision +stats_reset timestamp with time zone
changedpg_statistic_ext
--- 13 +++ 14 @@ -6,3 +6,4 @@ stxstattarget int4 stxkeys int2vector stxkind char[] +stxexprs pg_node_tree
changedpg_statistic_ext_data
--- 13 +++ 14 @@ -2,3 +2,4 @@ stxdndistinct pg_ndistinct stxddependencies pg_dependencies stxdmcv pg_mcv_list +stxdexpr pg_statistic[]
changedpg_stats_ext
--- 13 +++ 14 @@ -4,6 +4,7 @@ statistics_name name statistics_owner name attnames name[] +exprs text[] kinds char[] n_distinct pg_ndistinct dependencies pg_dependencies
addedpg_stats_ext_exprs
--- 13 +++ 14 @@ -0,0 +1,16 @@ +schemaname name +tablename name +statistics_schemaname name +statistics_name name +statistics_owner name +expr text +null_frac float4 +avg_width int4 +n_distinct float4 +most_common_vals anyarray +most_common_freqs float4[] +histogram_bounds anyarray +correlation float4 +most_common_elems anyarray +most_common_elem_freqs float4[] +elem_count_histogram float4[]
changedpg_subscription
--- 13 +++ 14 @@ -3,6 +3,8 @@ subname name subowner oid subenabled bool +subbinary bool +substream bool subconninfo text subslotname name subsynccommit text
changedpg_type
--- 13 +++ 14 @@ -10,6 +10,7 @@ typisdefined bool typdelim char typrelid oid +typsubscript regproc typelem oid typarray oid typinput regproc