SYSTEM CATALOGS / VERSION COMPARISON
What changed?
System Catalogs · PostgreSQL 17 → 18
2 added · 0 removed · 16 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedpg_aios
--- 17 +++ 18 @@ -0,0 +1,15 @@ +pid int4 +io_id int4 +io_generation int8 +state text +operation text +off int8 +length int8 +target text +handle_data_len int2 +raw_result int4 +result text +target_desc text +f_sync bool +f_localmem bool +f_buffered bool
changedpg_attribute
--- 17 +++ 18 @@ -3,7 +3,6 @@ atttypid oid attlen int2 attnum int2 -attcacheoff int4 atttypmod int4 attndims int2 attbyval bool
changedpg_backend_memory_contexts
--- 17 +++ 18 @@ -1,7 +1,8 @@ name text ident text -parent text +type text level int4 +path int4[] total_bytes int8 total_nblocks int8 free_bytes int8
changedpg_class
--- 17 +++ 18 @@ -10,6 +10,7 @@ relpages int4 reltuples float4 relallvisible int4 +relallfrozen int4 reltoastrelid oid relhasindex bool relisshared bool
changedpg_constraint
--- 17 +++ 18 @@ -4,6 +4,7 @@ contype char condeferrable bool condeferred bool +conenforced bool convalidated bool conrelid oid contypid oid @@ -16,6 +17,7 @@ conislocal bool coninhcount int2 connoinherit bool +conperiod bool conkey int2[] confkey int2[] conpfeqop oid[]
changedpg_publication
--- 17 +++ 18 @@ -7,3 +7,4 @@ pubdelete bool pubtruncate bool pubviaroot bool +pubgencols char
changedpg_replication_slots
--- 17 +++ 18 @@ -13,6 +13,7 @@ wal_status text safe_wal_size int8 two_phase bool +two_phase_at pg_lsn inactive_since timestamptz conflicting bool invalidation_reason text
addedpg_shmem_allocations_numa
--- 17 +++ 18 @@ -0,0 +1,3 @@ +name text +numa_node int4 +size int8
changedpg_stat_all_tables
--- 17 +++ 18 @@ -24,3 +24,7 @@ autovacuum_count bigint analyze_count bigint autoanalyze_count bigint +total_vacuum_time double precision +total_autovacuum_time double precision +total_analyze_time double precision +total_autoanalyze_time double precision
changedpg_stat_checkpointer
--- 17 +++ 18 @@ -1,9 +1,11 @@ num_timed bigint num_requested bigint +num_done bigint restartpoints_timed bigint restartpoints_req bigint restartpoints_done bigint write_time double precision sync_time double precision buffers_written bigint +slru_written bigint stats_reset timestamp with time zone
changedpg_stat_database
--- 17 +++ 18 @@ -25,4 +25,6 @@ sessions_abandoned bigint sessions_fatal bigint sessions_killed bigint +parallel_workers_to_launch bigint +parallel_workers_launched bigint stats_reset timestamp with time zone
changedpg_stat_io
--- 17 +++ 18 @@ -2,14 +2,16 @@ object text context text reads bigint +read_bytes numeric read_time double precision writes bigint +write_bytes numeric write_time double precision writebacks bigint writeback_time double precision extends bigint +extend_bytes numeric extend_time double precision -op_bytes bigint hits bigint evictions bigint reuses bigint
changedpg_stat_progress_analyze
--- 17 +++ 18 @@ -10,3 +10,4 @@ child_tables_total bigint child_tables_done bigint current_child_table_relid oid +delay_time double precision
changedpg_stat_progress_vacuum
--- 17 +++ 18 @@ -12,3 +12,4 @@ num_dead_item_ids bigint indexes_total bigint indexes_processed bigint +delay_time double precision
changedpg_stat_subscription_stats
--- 17 +++ 18 @@ -2,4 +2,11 @@ subname name apply_error_count bigint sync_error_count bigint +confl_insert_exists bigint +confl_update_origin_differs bigint +confl_update_exists bigint +confl_update_missing bigint +confl_delete_origin_differs bigint +confl_delete_missing bigint +confl_multiple_unique_conflicts bigint stats_reset timestamp with time zone
changedpg_stat_sys_tables
--- 17 +++ 18 @@ -24,3 +24,7 @@ autovacuum_count bigint analyze_count bigint autoanalyze_count bigint +total_vacuum_time double precision +total_autovacuum_time double precision +total_analyze_time double precision +total_autoanalyze_time double precision
changedpg_stat_user_tables
--- 17 +++ 18 @@ -24,3 +24,7 @@ autovacuum_count bigint analyze_count bigint autoanalyze_count bigint +total_vacuum_time double precision +total_autovacuum_time double precision +total_analyze_time double precision +total_autoanalyze_time double precision
changedpg_stat_wal
--- 17 +++ 18 @@ -2,8 +2,4 @@ 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