Re: Reading WALs

2020-03-14 Thread Peter Eisentraut
On 2020-03-14 14:48, PegoraroF10 wrote: On my built in logical replication I see that sometimes it tooks a long time to be updated with master. The question is how can I see what is being done on replica ? I know I can have a WAL reader, I tried WAL2JSON, it listen all data which comes from maste

Re: Reading WALs

2020-03-14 Thread Adrian Klaver
On 3/14/20 10:11 AM, PegoraroF10 wrote: pg_Stat_Subscription does not anwer what I want. This view just show if replication is being processed but not exactly what it´s doing. Is it replicating a huge table which an erroneous proess updated several times ? Replication process is recreating what i

Re: Reading WALs

2020-03-14 Thread PegoraroF10
pg_Stat_Subscription does not anwer what I want. This view just show if replication is being processed but not exactly what it´s doing. Is it replicating a huge table which an erroneous proess updated several times ? Replication process is recreating what index and that is spending how much time ?

Re: Reading WALs

2020-03-14 Thread Adrian Klaver
On 3/14/20 6:48 AM, PegoraroF10 wrote: On my built in logical replication I see that sometimes it tooks a long time to be updated with master. The question is how can I see what is being done on replica ? I know I can have a WAL reader, I tried WAL2JSON, it listen all data which comes from master

Reading WALs

2020-03-14 Thread PegoraroF10
On my built in logical replication I see that sometimes it tooks a long time to be updated with master. The question is how can I see what is being done on replica ? I know I can have a WAL reader, I tried WAL2JSON, it listen all data which comes from master, but as I understood when I use that plu