pg_stat_replication_slots

A statistics view showing statistics about logical replication slot usage
This entry relates to a PostgreSQL feature which is part of PostgreSQL 14, due to be released in late 2021.

pg_stat_replication_slots is a statistics view showing statistics about logical replication slot usage, specifically about transactions spilled to disk from the ReorderBuffer.

pg_stat_replication_slots was added in PostgreSQL 14.

Resetting statistics

Statistics for a particular logical replication slot can be reset by calling the function pg_stat_reset_replication_slot(slot_name).

Statistics for all logical replication slots can be reset by calling pg_stat_reset_replication_slot(NULL).

Change history

Categories

Logical replication, Statistics / monitoring view

See also

pg_stat_reset_replication_slot()