On Thu, 2024-01-25 at 12:18 -0500, Ron Johnson wrote: > PG 14.10 (and 9.6.24, which we're migrating off of). > > EXPLAIN SELECT works inside a FOR loop, but only the first line of the EXPLAIN > output is stored. What's the magic sauce for seeing the whole EXPLAIN output?
DECLARE _v_explain jsonb; BEGIN EXECUTE 'EXPLAIN (FORMAT JSON) select ...' INTO _v_explain; RAISE NOTICE '%', _v_explain; END; Yours, Laurenz Albe
