FOLLOW THE EVOLUTION

PostgreSQL 13 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 12 → 13

pg_available_extension_versionsStructural change

+ trusted

pg_pltemplateCatalog removed

− tmplname− tmpltrusted− tmpldbacreate− tmplhandler− tmplinline− tmplvalidator− tmpllibrary− tmplacl

pg_publicationStructural change

+ pubviaroot

pg_replication_slotsStructural change

+ wal_status+ safe_wal_size

pg_shmem_allocationsCatalog added

+ name+ off+ size+ allocated_size

pg_stat_activityStructural change

+ leader_pid

pg_stat_all_tablesStructural change

+ n_ins_since_vacuum

pg_stat_progress_analyzeCatalog added

+ pid+ datid+ datname+ relid+ phase+ sample_blks_total+ sample_blks_scanned+ ext_stats_total+ ext_stats_computed+ child_tables_total+ child_tables_done+ current_child_table_relid

pg_stat_progress_basebackupCatalog added

+ pid+ phase+ backup_total+ backup_streamed+ tablespaces_total+ tablespaces_streamed

pg_stat_slruCatalog added

+ name+ blks_zeroed+ blks_hit+ blks_read+ blks_written+ blks_exists+ flushes+ truncates+ stats_reset

pg_stat_sys_tablesStructural change

+ n_ins_since_vacuum

pg_stat_user_tablesStructural change

+ n_ins_since_vacuum

pg_stat_wal_receiverStructural change

+ written_lsn+ flushed_lsn− received_lsn

pg_statistic_extStructural change

+ stxstattarget

pg_subscriptionStructural change

~ subslotname: not_null: true → false

pg_subscription_relStructural change

~ srsublsn: not_null: true → false

pg_triggerStructural change

+ tgparentid