THE POSTGRESQL CATALOG ATLAS

Read every step ofPostgreSQL's evolution.

From 9.0 to today, follow the thread of the system catalogs,
explore the database's internal structure, and find what changed between versions.

Compare versions ↗Get the open data ↓

17major versions

157catalogs and views

2010 — 2026sixteen years of change

Official docs · reproducible data ↗

EXPLORE THE CATALOG

One view of every version.

19 beta 3 · preview

Catalog availability by PostgreSQL version and structural changes between adjacent versions
Catalog 157
pg_aggregateCAT
pg_aiosVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_amCAT
pg_amopCAT
pg_amprocCAT
pg_attrdefCAT
pg_attributeCAT
pg_auth_membersCAT
pg_authidCAT
pg_available_extension_versionsVIEW	–
pg_available_extensionsVIEW	–
pg_backend_memory_contextsVIEW	–	–	–	–	–	–	–	–	–	–	–
pg_castCAT
pg_classCAT
pg_collationCAT	–
pg_configVIEW	–	–	–	–	–	–
pg_constraintCAT
pg_conversionCAT
pg_cursorsVIEW
pg_databaseCAT
pg_db_role_settingCAT
pg_default_aclCAT
pg_dependCAT
pg_descriptionCAT
pg_dsm_registry_allocationsVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_enumCAT
pg_event_triggerCAT	–	–	–
pg_extensionCAT	–
pg_file_settingsVIEW	–	–	–	–	–
pg_foreign_data_wrapperCAT
pg_foreign_serverCAT
pg_foreign_tableCAT	–
pg_groupVIEW
pg_hba_file_rulesVIEW	–	–	–	–	–	–	–
pg_ident_file_mappingsVIEW	–	–	–	–	–	–	–	–	–	–	–	–
pg_indexCAT
pg_indexesVIEW
pg_inheritsCAT
pg_init_privsCAT	–	–	–	–	–	–
pg_languageCAT
pg_largeobjectCAT
pg_largeobject_metadataCAT
pg_locksVIEW
pg_matviewsVIEW	–	–	–
pg_namespaceCAT
pg_opclassCAT
pg_operatorCAT
pg_opfamilyCAT
pg_parameter_aclCAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_partitioned_tableCAT	–	–	–	–	–	–	–
pg_pltemplateCAT											–	–	–	–	–	–	–
pg_policiesVIEW	–	–	–	–	–
pg_policyCAT	–	–	–	–	–
pg_prepared_statementsVIEW
pg_prepared_xactsVIEW
pg_procCAT
pg_propgraph_elementCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_element_labelCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_labelCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_label_propertyCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_propgraph_propertyCAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_publicationCAT	–	–	–	–	–	–	–
pg_publication_namespaceCAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_publication_relCAT	–	–	–	–	–	–	–
pg_publication_sequencesVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_publication_tablesVIEW	–	–	–	–	–	–	–
pg_rangeCAT	–	–
pg_replication_originCAT	–	–	–	–	–
pg_replication_origin_statusVIEW	–	–	–	–	–
pg_replication_slotsVIEW	–	–	–	–
pg_rewriteCAT
pg_rolesVIEW
pg_rulesVIEW
pg_seclabelCAT	–
pg_seclabelsVIEW	–
pg_sequenceCAT	–	–	–	–	–	–	–
pg_sequencesVIEW	–	–	–	–	–	–	–
pg_settingsVIEW
pg_shadowVIEW
pg_shdependCAT
pg_shdescriptionCAT
pg_shmem_allocationsVIEW	–	–	–	–	–	–	–	–	–	–
pg_shmem_allocations_numaVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_shseclabelCAT	–	–
pg_stat_activitySTAT
pg_stat_all_indexesSTAT
pg_stat_all_tablesSTAT
pg_stat_archiverSTAT	–	–	–	–
pg_stat_autovacuum_scoresSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_bgwriterSTAT
pg_stat_checkpointerSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_databaseSTAT
pg_stat_database_conflictsSTAT	–
pg_stat_gssapiSTAT	–	–	–	–	–	–	–	–	–
pg_stat_ioSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_lockSTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_analyzePROG	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_basebackupPROG	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_clusterPROG	–	–	–	–	–	–	–	–	–
pg_stat_progress_copyPROG	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_create_indexPROG	–	–	–	–	–	–	–	–	–
pg_stat_progress_data_checksumsPROG	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_repackPROG	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_progress_vacuumPROG	–	–	–	–	–	–
pg_stat_recoverySTAT	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_recovery_prefetchSTAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_replicationSTAT	–
pg_stat_replication_slotsSTAT	–	–	–	–	–	–	–	–	–	–	–
pg_stat_slruSTAT	–	–	–	–	–	–	–	–	–	–
pg_stat_sslSTAT	–	–	–	–	–
pg_stat_subscriptionSTAT	–	–	–	–	–	–	–
pg_stat_subscription_statsSTAT	–	–	–	–	–	–	–	–	–	–	–	–
pg_stat_sys_indexesSTAT
pg_stat_sys_tablesSTAT
pg_stat_user_functionsSTAT
pg_stat_user_indexesSTAT
pg_stat_user_tablesSTAT
pg_stat_walSTAT	–	–	–	–	–	–	–	–	–	–	–
pg_stat_wal_receiverSTAT	–	–	–	–	–	–
pg_stat_xact_all_tablesSTAT	–
pg_stat_xact_sys_tablesSTAT	–
pg_stat_xact_user_functionsSTAT	–
pg_stat_xact_user_tablesSTAT	–
pg_statio_all_indexesSTAT
pg_statio_all_sequencesSTAT
pg_statio_all_tablesSTAT
pg_statio_sys_indexesSTAT
pg_statio_sys_sequencesSTAT
pg_statio_sys_tablesSTAT
pg_statio_user_indexesSTAT
pg_statio_user_sequencesSTAT
pg_statio_user_tablesSTAT
pg_statisticCAT
pg_statistic_extCAT	–	–	–	–	–	–	–
pg_statistic_ext_dataCAT	–	–	–	–	–	–	–	–	–
pg_statsVIEW
pg_stats_extVIEW	–	–	–	–	–	–	–	–	–
pg_stats_ext_exprsVIEW	–	–	–	–	–	–	–	–	–	–	–
pg_subscriptionCAT	–	–	–	–	–	–	–
pg_subscription_relCAT	–	–	–	–	–	–	–
pg_tablesVIEW
pg_tablespaceCAT
pg_timezone_abbrevsVIEW
pg_timezone_namesVIEW
pg_transformCAT	–	–	–	–	–
pg_triggerCAT
pg_ts_configCAT
pg_ts_config_mapCAT
pg_ts_dictCAT
pg_ts_parserCAT
pg_ts_templateCAT
pg_typeCAT
pg_userVIEW
pg_user_mappingCAT
pg_user_mappingsVIEW
pg_viewsVIEW
pg_wait_eventsVIEW	–	–	–	–	–	–	–	–	–	–	–	–	–	–

Click a catalog for its columns and evolution timeline; click a version cell to jump straight to that version. A structural change means an added or removed column or a changed type. Description wording is tracked separately.