pg_stat_subscription_stats.subid

Description

OID of the subscription

View

pg_stat_subscription_stats

Field

subid

SQL type

oid

Units named in the field definition

Not specified

Reset observation

Time at which these statistics were last reset

Usage

SELECT subid 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 subid FROM pg_catalog.pg_stat_subscription_stats;

Related entries

• pg_stat_subscription_stats columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 14 → 15: added.

--- PostgreSQL 14
+++ PostgreSQL 15
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "subid",
+  "sql_type": "oid",
+  "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.apply_error_count
• pg_stat_subscription_stats.confl_delete_missing
• pg_stat_subscription_stats.confl_delete_origin_differs
• pg_stat_subscription_stats.confl_insert_exists
• pg_stat_subscription_stats.confl_multiple_unique_conflicts
• pg_stat_subscription_stats.confl_update_exists
• pg_stat_subscription_stats.confl_update_missing
• pg_stat_subscription_stats.confl_update_origin_differs
• pg_stat_subscription_stats.stats_reset
• pg_stat_subscription_stats.subname
• pg_stat_subscription_stats.sync_error_count