Yes. But as we are using bind variables, we are not able to get the ID of the tuple.
On Thu, Jul 17, 2014 at 2:08 PM, Douglas J Hunley <doug.hun...@gmail.com> wrote: > > On Thu, Jul 17, 2014 at 12:54 PM, AI Rumman <rumman...@gmail.com> wrote: > >> I am experiencing lock contention on one single UPDATE statement at a >> certain time in whole day. This is a small table to UPDATE. >> My suspect is we are facing it for one specific ID. >> Could you please let me know how can I identify the tuple. >> > > Have you tried the lock monitoring queries on > http://wiki.postgresql.org/wiki/Lock_Monitoring yet by chance? > > > > -- > Douglas J Hunley (doug.hun...@gmail.com) >