determining the locks that will be held by a query

Поиск
Список
Период
Сортировка
От Brian Cox
Тема determining the locks that will be held by a query
Дата
Msg-id 49DF9867.90108@ca.com
обсуждение исходный текст
Ответы Re: determining the locks that will be held by a query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: Using IOZone to simulate DB access patterns
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Using IOZone to simulate DB access patterns