peek_changes
View pending changes in a logical replication slot without consuming them. Returns up to a specified number of change records.
Instructions
Peek at pending changes in a slot WITHOUT consuming them.
Deterministic. Wraps pg_logical_slot_peek_changes — the peek variant,
not get — so inspecting the queue does not advance the slot or consume
the changes. Returns up to limit rows of (lsn, xid, data). The data
rendering depends on the slot's output plugin: text for test_decoding,
binary for pgoutput. Run this on the PUBLISHER.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| slot_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |