determining the locks that will be held by a query

From: Brian Cox <brian(dot)cox(at)ca(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: determining the locks that will be held by a query
Date: 2009-04-07 18:05:29
Message-ID: 49DB95E9.3030300@ca.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I know that EXPLAIN will show the query plan. I know that pg_locks will
show the locks currently held for activity transactions. Is there a way
to determine what locks a query will hold when it is executed?

Thanks,
Brian

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-04-07 19:24:23 Re: plpgsql arrays
Previous Message Andrew Sullivan 2009-04-07 17:18:04 Re: Best replication solution?