On Wed, Nov 26, 2014 at 1:57 PM, Dev Kumkar wrote:
> Can you let me know what exact details should be provided here?
>
You could start with the version of Postgres you're using.
Thanks Bill !
On Wed, Nov 26, 2014 at 9:07 AM, Bill Moran
wrote:
> In addition to what you're getting from that query, include the xact_start
> and
> state_change columns from pg_stat_activity. My guess is that your code is
> starting a transaction, then running a query, then processing the quer
On Wed, 26 Nov 2014 02:37:51 +0530
Dev Kumkar wrote:
> Am debugging a race condition scenario where multiple transaction are
> running in parallel and there are insert/update these transactions are
> performing.
>
> I was able to identify the blocking query and blocked query using following
> SQ
