Determine which query prevents applying WALs on standby

From: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Determine which query prevents applying WALs on standby
Date: 2018-09-06 12:09:41
Message-ID: CAJw4d1WDwy9CBvuagZDfHbjWmU3smfBR4X2uxL698e7m5JZzxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there a way to detect which query (or queries) on hot standby holds
streaming replication? Looked into the sources and found out that
function ResolveRecoveryConflictWithVirtualXIDs do that job but have
no idea how to do that with SQL.

--
With best regards, Andrey Zhidenkov.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2018-09-06 15:32:58 Re: recovery.conf not getting changed to recovery.done after PITR
Previous Message Achilleas Mantzios 2018-09-06 06:42:52 Re: User to get locked after three wrong login attempts.