| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: |
| Date: | 2024-01-26 08:23:54 |
| Message-ID: | 15be52da1fd694e224b803743b43046f489bfaab.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pf | 2024-01-26 18:34:25 | Re: permission denied on socket |
| Previous Message | Jawala | 2024-01-26 04:34:43 | Feature Request: log_line_prefix %h Counterpart |