Postgres Pro
Downloads
Home   >   mailing lists

Thread: determining the locks that will be held by a query

determining the locks that will be held by a query

From
Brian Cox
Date:
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