pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Determine which query prevents applying WALs on standby 2+ messages / 2 participants [nested] [flat]
* Determine which query prevents applying WALs on standby @ 2018-09-06 12:09 Andrey Zhidenkov <andrey.zhidenkov@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Andrey Zhidenkov @ 2018-09-06 12:09 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Determine which query prevents applying WALs on standby @ 2018-09-06 15:35 Jerry Sievers <gsievers19@comcast.net> parent: Andrey Zhidenkov <andrey.zhidenkov@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Jerry Sievers @ 2018-09-06 15:35 UTC (permalink / raw) To: Andrey Zhidenkov <andrey.zhidenkov@gmail.com>; +Cc: pgsql-admin Andrey Zhidenkov <andrey.zhidenkov@gmail.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.consulting@comcast.net p: 312.241.7800 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-09-06 15:35 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-09-06 12:09 Determine which query prevents applying WALs on standby Andrey Zhidenkov <andrey.zhidenkov@gmail.com> 2018-09-06 15:35 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox