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.klaver@xxxxxxxxxxx
