Postgres Pro
Downloads
Home   >   mailing lists

determining the locks that will be held by a query - Mailing list pgsql-performance

From Brian Cox
Subject determining the locks that will be held by a query
Date
Msg-id 49DB95E9.3030300@ca.com
Whole thread Raw
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Best replication solution?
Next
From: Merlin Moncure
Date:
Subject: Re: plpgsql arrays