Re: Whats is lock type transactionid?

From: Douglas J Hunley <doug(dot)hunley(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Whats is lock type transactionid?
Date: 2014-07-17 21:08:18
Message-ID: CALxYTP7-Oz2P3_VhX4O19zrqRz2c6pWDi6dxGNThfW-A10oD3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lists 2014-07-17 22:50:12 Detect streaming replication failure
Previous Message AI Rumman 2014-07-17 19:54:00 Re: Whats is lock type transactionid?