Postgres Pro
Downloads
Home   >   mailing lists

Re: Whats is lock type transactionid? - Mailing list pgsql-general

From AI Rumman
Subject Re: Whats is lock type transactionid?
Date
Msg-id CAGoODpdqSuY==HVQyNNT4qFZuBZHN7jTRviWNg5PztEZ1L_GOw@mail.gmail.com
Whole thread Raw
In response to Re: Whats is lock type transactionid?  (Douglas J Hunley <doug.hunley@gmail.com>)
List pgsql-general
Tree view
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.hunley@gmail.com> wrote:

On Thu, Jul 17, 2014 at 12:54 PM, AI Rumman <rummandba@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.hunley@gmail.com)

pgsql-general by date:

Previous
From: Lists
Date:
Subject: Detect streaming replication failure
Next
From: Prabhjot Sheena
Date:
Subject: Re: Checkpoint_segments optimal value