Every version checked against a live instance.

17 / 17 versions measured · 2032 relation snapshots · 19171 column records. A further 5934 common system-column records are kept separately.

These counts cover every core ordinary catalog table and view in that version, including statistics views, progress views, and the variants that actually exist. Indexes, TOAST tables, functions, catalog data rows, and extension-created objects are not counted as separate catalog tables. Common system attributes such as xmin and ctid stay in each snapshot's system_columns and are not mixed in with ordinary columns.

What this round corrected

The original documentation has its own omissions, spelling slips, and wrong types. The table below keeps the differences between the documentation and the real structure; the source documents were not overwritten. Calibrated types come from format_type on the corresponding release; column names, order, type OIDs, nullability, and array dimensions come from pg_attribute.

28 correction records

Version	Columns	Corrected	Documented	Calibrated
9.0	pg_user.usesysid	Type	integer	oid
9.0	pg_user_mappings.srvname	Type	text	name
9.1	pg_shadow.userepl	Presence	false	true
9.1	pg_user.usesysid	Type	integer	oid
9.1	pg_user.userepl	Presence	false	true
9.1	pg_user_mappings.srvname	Type	text	name
9.4	pg_replication_slots.database	Type	text	name
9.5	pg_replication_slots.database	Type	text	name
9.6	pg_replication_slots.database	Type	text	name
10	pg_partitioned_table.partcollation	Reference	pg_opclass.oid	pg_collation.oid
10	pg_policies.permissive	Name	polpermissive	permissive
10	pg_replication_slots.database	Type	text	name
10	pg_stat_subscription.subname	Type	text	name
11	pg_partitioned_table.partcollation	Reference	pg_opclass.oid	pg_collation.oid
11	pg_policies.permissive	Name	polpermissive	permissive
11	pg_replication_slots.database	Type	text	name
11	pg_stat_subscription.subname	Type	text	name
12	pg_partitioned_table.partcollation	Reference	pg_opclass.oid	pg_collation.oid
12	pg_policies.permissive	Name	polpermissive	permissive
12	pg_replication_slots.database	Type	text	name
12	pg_stat_subscription.subname	Type	text	name
12	pg_stats_ext.statistics_owner	Type	oid	name
12	pg_stats_ext.kinds	Type	text[]	"char"[]
12	pg_stats_ext.most_common_vals	Type	anyarray	text[]
12	pg_stats_ext.most_common_val_nulls	Type	anyarray	boolean[]
12	pg_stats_ext.most_common_freqs	Type	real[]	double precision[]
12	pg_stats_ext.most_common_base_freqs	Type	real[]	double precision[]
12	pg_stats_ext.statistics_owner	Reference	pg_authid.oid	pg_authid.rolname

Download the full calibration report · Download the standalone source coverage report · Download the calibrated master data

How these results were produced

Each probe initialises its own extension-free temporary database listening on a private Unix socket only. 9.x and 19 beta 3 are built from the matching release source; 10 through 18 use official community packages of the exact minor version. Every probe result, its SQL, version numbers, build options, and SHA-256 are kept in the project. An offline rebuild reads the archive directly and does not require restarting a database.

9.0 and 9.1 use the semaphore lock option supplied by the original project on ARM64 for compatibility with the older code; compiler compatibility flags and build logs are recorded, and no catalog definition was modified. Cross-version differences are taken per exact release snapshot, with 19 pinned to REL_19_BETA3 rather than a moving development branch.

See the data formats, historical documents, and provenance notes →