determining which operation is blocking another query

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: determining which operation is blocking another query
Date: 2006-05-25 06:49:37
Message-ID: 6992E470F12A444BB787B5C937B9D4DF04997303@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

Is there a system view that can be used to determine which
INSERT/UPDATE/DELETE/Other Operation is blocking a SELECT statement.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2006-05-25 07:27:07 Re: determining which operation is blocking another query
Previous Message hubert depesz lubaczewski 2006-05-25 06:33:56 Re: How to mesure transaction rate in Postgres