Re: [PERFORM] determining the locks that will be held by a query

Brian Cox wrote: > 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? Only to read the docs regarding locking, and to desk-check your

[PERFORM] determining the locks that will be held by a query

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

[PERFORM] determining the locks that will be held by a query

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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.