Re: Monitoring Locks in Databases

From: <mallah(at)trade-india(dot)com>
To: <nwalker(at)eldocomp(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Monitoring Locks in Databases
Date: 2002-09-13 20:47:46
Message-ID: 1338.203.145.131.140.1031950066.squirrel@mail.trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi,

I think it will be possible in PGSQL 7.3 there exists somthing
like pg_locks

regds
mallah.

> We are using Postgres 7.1.2 on a Sun E3500 running Solaris 6.
>
> Is their some way to monitor database locks in Postgres (ie. how many and who owns the locks")?
> If not, do we foresee this happening in some later release?
>
> This would be very useful for us in debugging.
>
> Naomi
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo(at)postgresql(dot)org

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Mitchell 2002-09-13 21:04:55 Re: Monitoring Locks in Databases
Previous Message Mel Jamero 2002-09-13 19:11:56 Re: Vaccuum/Analyze