Request a Demo
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 49DF9867.90108@ca.com
Whole thread Raw
Responses Re: determining the locks that will be held by a query
List pgsql-performance
Tree view 
I sent this out on 4/7 and either missed a response or didn't get one.
If this is the wrong forum, I'd appreciate a redirect.

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: Scott Carey
Date:
Subject: Re: Using IOZone to simulate DB access patterns
Next
From: Greg Smith
Date:
Subject: Re: Using IOZone to simulate DB access patterns