Thread: Logical replication - SELECT * FROM pg_logical_slot_get_changes

Hi,

Just curious, what is the impact of running these and under  what scenario would you necessarily run them?

SELECT * FROM pg_logical_slot_get_changes('fivetran_replication_slot', NULL, NULL, 'stream-changes', '1');
SELECT * FROM pg_logical_slot_get_changes('fivetran_replication_slot', NULL, NULL, 'include-xids', '0');

Can you actually run this to tell logical replication to start/reset replicating from when?

Regards,

Ed