FOLLOW THE EVOLUTION

PostgreSQL 14 Catalog Changes

Start from a single upgrade and see how catalogs, columns, and types changed.
Compare any two versions, or walk forward through the release history.

FROMTOInclude description updates

PostgreSQL 13 → 14

pg_attributeStructural change

+ attcompression↕ Column order changed

pg_backend_memory_contextsCatalog added

+ name+ ident+ parent+ level+ total_bytes+ total_nblocks+ free_bytes+ free_chunks+ used_bytes

pg_inheritsStructural change

+ inhdetachpending

pg_locksStructural change

+ waitstart

pg_prepared_statementsStructural change

+ generic_plans+ custom_plans

pg_procStructural change

+ prosqlbody

pg_rangeStructural change

+ rngmultitypid

pg_replication_slotsStructural change

+ two_phase

pg_stat_activityStructural change

+ query_id

pg_stat_databaseStructural change

+ session_time+ active_time+ idle_in_transaction_time+ sessions+ sessions_abandoned+ sessions_fatal+ sessions_killed

pg_stat_progress_copyCatalog added

+ pid+ datid+ datname+ relid+ command+ type+ bytes_processed+ bytes_total+ tuples_processed+ tuples_excluded

pg_stat_replication_slotsCatalog added

+ slot_name+ spill_txns+ spill_count+ spill_bytes+ stream_txns+ stream_count+ stream_bytes+ total_txns+ total_bytes+ stats_reset

pg_stat_sslStructural change

− compression

pg_stat_walCatalog added

+ wal_records+ wal_fpi+ wal_bytes+ wal_buffers_full+ wal_write+ wal_sync+ wal_write_time+ wal_sync_time+ stats_reset

pg_statistic_extStructural change

+ stxexprs

pg_statistic_ext_dataStructural change

+ stxdexpr

pg_stats_extStructural change

+ exprs

pg_stats_ext_exprsCatalog added

+ schemaname+ tablename+ statistics_schemaname+ statistics_name+ statistics_owner+ expr+ null_frac+ avg_width+ n_distinct+ most_common_vals+ most_common_freqs+ histogram_bounds+ correlation+ most_common_elems+ most_common_elem_freqs+ elem_count_histogram

pg_subscriptionStructural change

+ subbinary+ substream

pg_typeStructural change

+ typsubscript