pg_stat_subscription_stats

PostgreSQL documentation ↗Source definition ↗

The pg_stat_subscription_stats view will contain one row per subscription.

First seen PG 15Last seen PG 19Columns 12

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_subscription_stats

COLUMN	TYPE	DESCRIPTION
`subid`	`oid`	OID of the subscription
`subname`	`name`	Name of the subscription
`apply_error_count`	`bigint`	Number of times an error occurred while applying changes. Note that any conflict resulting in an apply error will be counted in both apply_error_count and the corresponding conflict count (e.g., confl_*).
`sync_error_count`	`bigint`	Number of times an error occurred during the initial table synchronization
`confl_insert_exists`	`bigint`	Number of times a row insertion violated a NOT DEFERRABLE unique constraint during the application of changes. See insert_exists for details about this conflict.
`confl_update_origin_differs`	`bigint`	Number of times an update was applied to a row that had been previously modified by another source during the application of changes. See update_origin_differs for details about this conflict.
`confl_update_exists`	`bigint`	Number of times that an updated row value violated a NOT DEFERRABLE unique constraint during the application of changes. See update_exists for details about this conflict.
`confl_update_missing`	`bigint`	Number of times the tuple to be updated was not found during the application of changes. See update_missing for details about this conflict.
`confl_delete_origin_differs`	`bigint`	Number of times a delete operation was applied to row that had been previously modified by another source during the application of changes. See delete_origin_differs for details about this conflict.
`confl_delete_missing`	`bigint`	Number of times the tuple to be deleted was not found during the application of changes. See delete_missing for details about this conflict.
`confl_multiple_unique_conflicts`	`bigint`	Number of times a row insertion or an updated row values violated multiple NOT DEFERRABLE unique constraints during the application of changes. See multiple_unique_conflicts for details about this conflict.
`stats_reset`	`timestamp with time zone`	Time at which these statistics were last reset

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19
`subid`	–	–	–	–	–	–	–	–	–	–	–	–
`subname`	–	–	–	–	–	–	–	–	–	–	–	–
`apply_error_count`	–	–	–	–	–	–	–	–	–	–	–	–
`sync_error_count`	–	–	–	–	–	–	–	–	–	–	–	–					−
`stats_reset`	–	–	–	–	–	–	–	–	–	–	–	–
`confl_insert_exists`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_update_origin_differs`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_update_exists`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_update_missing`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_delete_origin_differs`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_delete_missing`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_multiple_unique_conflicts`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`sync_seq_error_count`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`sync_table_error_count`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`confl_update_deleted`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

+ sync_seq_error_count+ sync_table_error_count+ confl_update_deleted− sync_error_count

PostgreSQL 18 ← 17

+ confl_insert_exists+ confl_update_origin_differs+ confl_update_exists+ confl_update_missing+ confl_delete_origin_differs+ confl_delete_missing+ confl_multiple_unique_conflicts1 column description updates

PostgreSQL 15 ← 14Catalog added

+ subid+ subname+ apply_error_count+ sync_error_count+ stats_reset

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.