Обсуждение: determining the locks that will be held by a query

Поиск
Список
Период
Сортировка

determining the locks that will be held by a query

От
Brian Cox
Дата:
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