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
