Re: Determine which query prevents applying WALs on standby

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Determine which query prevents applying WALs on standby
Date: 2018-09-06 15:35:05
Message-ID: 87worywseu.fsf@jsievers.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com> writes:

> 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.

The pg_locks view on your standby should reveal something.

>
> --
> With best regards, Andrey Zhidenkov.
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Poul Kristensen 2018-09-06 17:26:36 Postgresql jdbc driver for PG version 9.5
Previous Message Jerry Sievers 2018-09-06 15:32:58 Re: recovery.conf not getting changed to recovery.done after PITR