Hi team, Would please remove me from it. Beat Regard, Zhenyu Xu -----邮件原件----- 发件人: Jerry Sievers <gsievers19@xxxxxxxxxxx> 发送时间: Thursday, September 6, 2018 23:35 收件人: Andrey Zhidenkov <andrey.zhidenkov@xxxxxxxxx> 抄送: pgsql-admin@xxxxxxxxxxxxxx 主题: Re: Determine which query prevents applying WALs on standby Andrey Zhidenkov <andrey.zhidenkov@xxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800
