EXPLAIN with anonymous DO block?

Поиск
Список
Период
Сортировка
От Ron
Тема EXPLAIN with anonymous DO block?
Дата
Msg-id a1a8a7f0-207f-2046-bb4a-348250bc08c0@gmail.com
обсуждение исходный текст
Ответы Re: EXPLAIN with anonymous DO block?  (Michael Lewis <mlewis@entrata.com>)
Re: EXPLAIN with anonymous DO block?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Postgresql 12.5

There's a query inside a DO block which -- because it's parameterized -- I'd 
rather analyze while it's in the FOR loop of a DO block, instead of pulling 
it out and hard-coding the parameters.

Is this possible?  If so, where do I put the EXPLAIN statement?

-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Damaged (during upgrade?) table, how to repair?
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: EXPLAIN with anonymous DO block?