pg_stat_replication_slots.slot_name

Description

A unique, cluster-wide identifier for the replication slot

View

pg_stat_replication_slots

Field

slot_name

SQL type

text

Units named in the field definition

Not specified

Reset observation

Time at which these statistics were last reset

Usage

SELECT slot_name FROM pg_catalog.pg_stat_replication_slots;

View semantics

The pg_stat_replication_slots view will contain one row per logical replication slot, showing statistics about its usage.

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 slot_name FROM pg_catalog.pg_stat_replication_slots;

Related entries

• pg_stat_replication_slots columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 13 → 14: added.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "slot_name",
+  "sql_type": "text",
+  "units_mentioned": [],
+  "view": "pg_stat_replication_slots"
+}

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_replication_slots.spill_bytes
• pg_stat_replication_slots.spill_count
• pg_stat_replication_slots.spill_txns
• pg_stat_replication_slots.stats_reset
• pg_stat_replication_slots.stream_bytes
• pg_stat_replication_slots.stream_count
• pg_stat_replication_slots.stream_txns
• pg_stat_replication_slots.total_bytes
• pg_stat_replication_slots.total_txns