Wiki / Statistics & Metrics / pg_stat_subscription_stats
pg_stat_subscription_stats.apply_error_count
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_*).
Reading PostgreSQL 18.6.
Description
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_*).
- View
- pg_stat_subscription_stats
- Field
- apply_error_count
- SQL type
- bigint
- Units named in the field definition
- Not specified
- Reset observation
- Time at which these statistics were last reset
Usage
SELECT apply_error_count FROM pg_catalog.pg_stat_subscription_stats;View semantics
The pg_stat_subscription_stats view will contain one row per subscription.
Collection and reset context
Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.
Inspect this field
Example query; no execution result or measured value is asserted.
SELECT apply_error_count FROM pg_catalog.pg_stat_subscription_stats;Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Compare versions
PostgreSQL 14 → 15: added.
--- PostgreSQL 14
+++ PostgreSQL 15
@@ -1 +1,6 @@
-Not recorded in this version
+{
+ "field": "apply_error_count",
+ "sql_type": "bigint",
+ "units_mentioned": [],
+ "view": "pg_stat_subscription_stats"
+}Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
pg_stat_subscription_stats.confl_delete_missingpg_stat_subscription_stats.confl_delete_origin_differspg_stat_subscription_stats.confl_insert_existspg_stat_subscription_stats.confl_multiple_unique_conflictspg_stat_subscription_stats.confl_update_existspg_stat_subscription_stats.confl_update_missingpg_stat_subscription_stats.confl_update_origin_differspg_stat_subscription_stats.stats_resetpg_stat_subscription_stats.subidpg_stat_subscription_stats.subnamepg_stat_subscription_stats.sync_error_count
Export JSON · Back to Statistics & Metrics · Recorded in PostgreSQL 15 through 20; the first sample is not necessarily its introduction.