SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 18 → 19 beta 3
Pre-release documentation. These definitions may change before the final release.
12 added · 0 removed · 34 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedpg_available_extension_versions
--- 18 +++ 19 beta 3 @@ -6,4 +6,5 @@ relocatable bool schema name requires name[] +location text comment text
changedpg_available_extensions
--- 18 +++ 19 beta 3 @@ -1,4 +1,5 @@ name name default_version text installed_version text +location text comment text
addedpg_dsm_registry_allocations
--- 18 +++ 19 beta 3 @@ -0,0 +1,3 @@ +name text +type text +size int8
changedpg_foreign_data_wrapper
--- 18 +++ 19 beta 3 @@ -3,5 +3,6 @@ fdwowner oid fdwhandler oid fdwvalidator oid +fdwconnection oid fdwacl aclitem[] fdwoptions text[]
addedpg_propgraph_element
--- 18 +++ 19 beta 3 @@ -0,0 +1,14 @@ +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[]
addedpg_propgraph_element_label
--- 18 +++ 19 beta 3 @@ -0,0 +1,3 @@ +oid oid +pgellabelid oid +pgelelid oid
addedpg_propgraph_label
--- 18 +++ 19 beta 3 @@ -0,0 +1,3 @@ +oid oid +pglpgid oid +pgllabel name
addedpg_propgraph_label_property
--- 18 +++ 19 beta 3 @@ -0,0 +1,4 @@ +oid oid +plppropid oid +plpellabelid oid +plpexpr pg_node_tree
addedpg_propgraph_property
--- 18 +++ 19 beta 3 @@ -0,0 +1,6 @@ +oid oid +pgppgid oid +pgpname name +pgptypid oid +pgptypmod int4 +pgpcollation oid
changedpg_publication
--- 18 +++ 19 beta 3 @@ -2,6 +2,7 @@ pubname name pubowner oid puballtables bool +puballsequences bool pubinsert bool pubupdate bool pubdelete bool
changedpg_publication_rel
--- 18 +++ 19 beta 3 @@ -1,5 +1,6 @@ oid oid prpubid oid prrelid oid +prexcept bool prqual pg_node_tree prattrs int2vector
addedpg_publication_sequences
--- 18 +++ 19 beta 3 @@ -0,0 +1,3 @@ +pubname name +schemaname name +sequencename name
changedpg_range
--- 18 +++ 19 beta 3 @@ -3,5 +3,10 @@ rngmultitypid oid rngcollation oid rngsubopc oid +rngconstruct2 regproc +rngconstruct3 regproc +rngmltconstruct0 regproc +rngmltconstruct1 regproc +rngmltconstruct2 regproc rngcanonical regproc rngsubdiff regproc
changedpg_replication_slots
--- 18 +++ 19 beta 3 @@ -19,3 +19,4 @@ invalidation_reason text failover bool synced bool +slotsync_skip_reason text
changedpg_stat_all_indexes
--- 18 +++ 19 beta 3 @@ -7,3 +7,4 @@ last_idx_scan timestamp with time zone idx_tup_read bigint idx_tup_fetch bigint +stats_reset timestamp with time zone
changedpg_stat_all_tables
--- 18 +++ 19 beta 3 @@ -28,3 +28,4 @@ total_autovacuum_time double precision total_analyze_time double precision total_autoanalyze_time double precision +stats_reset timestamp with time zone
addedpg_stat_autovacuum_scores
--- 18 +++ 19 beta 3 @@ -0,0 +1,12 @@ +relid oid +schemaname name +relname name +score double precision +xid_score double precision +mxid_score double precision +vacuum_score double precision +vacuum_insert_score double precision +analyze_score double precision +do_vacuum bool +do_analyze bool +for_wraparound bool
changedpg_stat_database_conflicts
--- 18 +++ 19 beta 3 @@ -6,3 +6,4 @@ confl_bufferpin bigint confl_deadlock bigint confl_active_logicalslot bigint +stats_reset timestamp with time zone
addedpg_stat_lock
--- 18 +++ 19 beta 3 @@ -0,0 +1,5 @@ +locktype text +waits bigint +wait_time double precision +fastpath_exceeded bigint +stats_reset timestamp with time zone
changedpg_stat_progress_analyze
--- 18 +++ 19 beta 3 @@ -11,3 +11,4 @@ child_tables_done bigint current_child_table_relid oid delay_time double precision +started_by text
changedpg_stat_progress_basebackup
--- 18 +++ 19 beta 3 @@ -4,3 +4,4 @@ backup_streamed bigint tablespaces_total bigint tablespaces_streamed bigint +backup_type text
addedpg_stat_progress_data_checksums
--- 18 +++ 19 beta 3 @@ -0,0 +1,10 @@ +pid integer +datid oid +datname name +phase text +databases_total bigint +databases_done bigint +relations_total bigint +relations_done bigint +blocks_total bigint +blocks_done bigint
addedpg_stat_progress_repack
--- 18 +++ 19 beta 3 @@ -0,0 +1,14 @@ +pid integer +datid oid +datname name +relid oid +command text +phase text +repack_index_relid oid +heap_tuples_scanned bigint +heap_tuples_inserted bigint +heap_tuples_updated bigint +heap_tuples_deleted bigint +heap_blks_total bigint +heap_blks_scanned bigint +index_rebuild_count bigint
changedpg_stat_progress_vacuum
--- 18 +++ 19 beta 3 @@ -13,3 +13,5 @@ indexes_total bigint indexes_processed bigint delay_time double precision +mode text +started_by text
addedpg_stat_recovery
--- 18 +++ 19 beta 3 @@ -0,0 +1,9 @@ +promote_triggered boolean +last_replayed_read_lsn pg_lsn +last_replayed_end_lsn pg_lsn +last_replayed_tli integer +replay_end_lsn pg_lsn +replay_end_tli integer +recovery_last_xact_time timestamp with time zone +current_chunk_start_time timestamp with time zone +pause_state text
changedpg_stat_replication_slots
--- 18 +++ 19 beta 3 @@ -5,6 +5,9 @@ stream_txns bigint stream_count bigint stream_bytes bigint +mem_exceeded_count bigint total_txns bigint total_bytes bigint +slotsync_skip_count bigint +slotsync_last_skip timestamp with time zone stats_reset timestamp with time zone
changedpg_stat_subscription_stats
--- 18 +++ 19 beta 3 @@ -1,10 +1,12 @@ subid oid subname name apply_error_count bigint -sync_error_count bigint +sync_seq_error_count bigint +sync_table_error_count bigint confl_insert_exists bigint confl_update_origin_differs bigint confl_update_exists bigint +confl_update_deleted bigint confl_update_missing bigint confl_delete_origin_differs bigint confl_delete_missing bigint
changedpg_stat_sys_indexes
--- 18 +++ 19 beta 3 @@ -7,3 +7,4 @@ last_idx_scan timestamp with time zone idx_tup_read bigint idx_tup_fetch bigint +stats_reset timestamp with time zone
changedpg_stat_sys_tables
--- 18 +++ 19 beta 3 @@ -28,3 +28,4 @@ total_autovacuum_time double precision total_analyze_time double precision total_autoanalyze_time double precision +stats_reset timestamp with time zone
changedpg_stat_user_functions
--- 18 +++ 19 beta 3 @@ -4,3 +4,4 @@ calls bigint total_time double precision self_time double precision +stats_reset timestamp with time zone
changedpg_stat_user_indexes
--- 18 +++ 19 beta 3 @@ -7,3 +7,4 @@ last_idx_scan timestamp with time zone idx_tup_read bigint idx_tup_fetch bigint +stats_reset timestamp with time zone
changedpg_stat_user_tables
--- 18 +++ 19 beta 3 @@ -28,3 +28,4 @@ total_autovacuum_time double precision total_analyze_time double precision total_autoanalyze_time double precision +stats_reset timestamp with time zone
changedpg_stat_wal
--- 18 +++ 19 beta 3 @@ -1,5 +1,6 @@ wal_records bigint wal_fpi bigint wal_bytes numeric +wal_fpi_bytes numeric wal_buffers_full bigint stats_reset timestamp with time zone
changedpg_statio_all_indexes
--- 18 +++ 19 beta 3 @@ -5,3 +5,4 @@ indexrelname name idx_blks_read bigint idx_blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_all_sequences
--- 18 +++ 19 beta 3 @@ -3,3 +3,4 @@ relname name blks_read bigint blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_all_tables
--- 18 +++ 19 beta 3 @@ -9,3 +9,4 @@ toast_blks_hit bigint tidx_blks_read bigint tidx_blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_sys_indexes
--- 18 +++ 19 beta 3 @@ -5,3 +5,4 @@ indexrelname name idx_blks_read bigint idx_blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_sys_sequences
--- 18 +++ 19 beta 3 @@ -3,3 +3,4 @@ relname name blks_read bigint blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_sys_tables
--- 18 +++ 19 beta 3 @@ -9,3 +9,4 @@ toast_blks_hit bigint tidx_blks_read bigint tidx_blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_user_indexes
--- 18 +++ 19 beta 3 @@ -5,3 +5,4 @@ indexrelname name idx_blks_read bigint idx_blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_user_sequences
--- 18 +++ 19 beta 3 @@ -3,3 +3,4 @@ relname name blks_read bigint blks_hit bigint +stats_reset timestamp with time zone
changedpg_statio_user_tables
--- 18 +++ 19 beta 3 @@ -9,3 +9,4 @@ toast_blks_hit bigint tidx_blks_read bigint tidx_blks_hit bigint +stats_reset timestamp with time zone
changedpg_stats
--- 18 +++ 19 beta 3 @@ -1,6 +1,8 @@ schemaname name tablename name +tableid oid attname name +attnum int2 inherited bool null_frac float4 avg_width int4
changedpg_stats_ext
--- 18 +++ 19 beta 3 @@ -1,7 +1,9 @@ schemaname name tablename name +tableid oid statistics_schemaname name statistics_name name +statistics_id oid statistics_owner name attnames name[] exprs text[]
changedpg_stats_ext_exprs
--- 18 +++ 19 beta 3 @@ -1,7 +1,9 @@ schemaname name tablename name +tableid oid statistics_schemaname name statistics_name name +statistics_id oid statistics_owner name expr text inherited bool @@ -15,3 +17,6 @@ most_common_elems anyarray most_common_elem_freqs float4[] elem_count_histogram float4[] +range_length_histogram anyarray +range_empty_frac float4 +range_bounds_histogram anyarray
changedpg_subscription
--- 18 +++ 19 beta 3 @@ -11,8 +11,13 @@ subpasswordrequired bool subrunasowner bool subfailover bool +subretaindeadtuples bool +submaxretention int4 +subretentionactive bool +subserver oid subconninfo text subslotname name subsynccommit text +subwalrcvtimeout text subpublications text[] suborigin text