<row>

<entry><structname>pg_stat_replication_slots</structname><indexterm><primary>pg_stat_replication_slots</primary></indexterm></entry>

<entry>One row per replication slot, showing statistics about

replication slot usage.

thereplication slot's usage.

See <link linkend="monitoring-pg-stat-replication-slots-view">

<structname>pg_stat_replication_slots</structname></link> for details.

</entry>

<structfield>spill_txns</structfield> <type>bigint</type>

</para>

<para>

Number of transactions spilled to diskafter the memory used by

logical decodingofchanges from WALfor this slot exceeds

Number of transactions spilled to diskonce the memory used by

logical decodingto decodechanges from WALhas exceeded

<literal>logical_decoding_work_mem</literal>. The counter gets

incrementedbothfor toplevel transactions and subtransactions.

incremented for both toplevel transactions and subtransactions.

</para></entry>

</row>

<structfield>spill_count</structfield> <type>bigint</type>

</para>

<para>

Number of times transactions were spilled to disk while decoding changes

from WAL for this slot. Transactions may get spilled repeatedly, and

this counter gets incremented on every such invocation.

Number of times transactions were spilled to disk while decoding

changes from WAL for this slot. This counter is incremented each time

a transaction is spilled, and the same transaction may be spilled

multiple times.

</para></entry>

</row>

<structfield>stream_txns</structfield> <type>bigint</type>

</para>

<para>

Number of in-progress transactions streamed to the decoding output plugin

after the memory used by logical decoding of changes from WAL for this

slot exceeds <literal>logical_decoding_work_mem</literal>. Streaming only

Number of in-progress transactions streamed to the decoding output

plugin after the memory used by logical decoding to decode changes

from WAL for this slot has exceeded

<literal>logical_decoding_work_mem</literal>. Streaming only

works with toplevel transactions (subtransactions can't be streamed

independently), so the counterdoes not get incremented for subtransactions.

independently), so the counteris not incremented for subtransactions.

</para></entry>

</row>

</para>

<para>

Number of times in-progress transactions were streamed to the decoding

output plugin while decoding changes from WAL for this slot.Transactions

such invocation.

output plugin while decoding changes from WAL for this slot.This

same transaction may be streamed multiple times.

</para></entry>

</row>

</row>

<row>

<entry role="func_table_entry"><para role="func_signature">

<entry role="func_table_entry"><para role="func_signature">

<indexterm>

<primary>pg_stat_reset_replication_slot</primary>

</indexterm>

<function>pg_stat_reset_replication_slot</function> ( <type>text</type> )

<returnvalue>void</returnvalue>

</para>

<para>

Resets statistics to zero for a single replication slot, or for all

replication slots in the cluster. The argument can be either the name

of the slot to reset the stats or NULL. If the argument is NULL, all

counters shown in the <structname>pg_stat_replication_slots</structname>

view for all replication slots are reset.

Resets statistics of the replication slot defined by the argument. If

the argument is <literal>NULL</literal>, resets statistics for all

the replication slots.

</para>

<para>

This function is restricted to superusers by default, but other users