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

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: determining the locks that will be held by a query
Дата
Msg-id 49DF5F7A.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на determining the locks that will be held by a query  (Brian Cox <brian.cox@ca.com>)
Список pgsql-performance
Brian Cox <brian.cox@ca.com> 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 query,
at least as far as I know.

Keep in mind that some statements will only obtain locks if they find
rows that are affected, which might vary from one run to the next.

-Kevin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Using IOZone to simulate DB access patterns
Следующее
От: Glyn Astill
Дата:
Сообщение: 2.6.26 kernel and PostgreSQL