Re: Reading WALs - Mailing list pgsql-general

From PegoraroF10
Subject Re: Reading WALs
Date
Msg-id 1584205871306-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Reading WALs  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Reading WALs  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.
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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Reading WALs
Next
From: Adrian Klaver
Date:
Subject: Re: Reading WALs