EXPLAIN with anonymous DO block?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: EXPLAIN with anonymous DO block?
Date: 2021-07-01 16:16:25
Message-ID: a1a8a7f0-207f-2046-bb4a-348250bc08c0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2021-07-01 16:21:39 Re: EXPLAIN with anonymous DO block?
Previous Message Laurenz Albe 2021-07-01 14:19:25 Re: Damaged (during upgrade?) table, how to repair?