From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Reading WALs |
Date: | 2020-03-14 18:17:46 |
Message-ID: | 33e68810-f339-906b-7266-5d09a918e09c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 index and that is spending how much
> time ?
> What WAL, table, operation is the one being processed ?
>
> So I would like to have a listener on replica server just to see all WAL
> info is coming, just that.
Any of the below helpful?:
https://www.postgresql.org/docs/12/logicaldecoding-example.html
> Then I can go back to production and see what´s could run better, if
> application, triggers and so on.
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2020-03-15 05:53:53 | Re: Reading WALs |
Previous Message | PegoraroF10 | 2020-03-14 17:11:11 | Re: Reading WALs |