Re: jit and explain nontext - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: jit and explain nontext
Date
Msg-id e5f51922-a6af-4ada-62fa-a18ca6d0b469@enterprisedb.com
Whole thread Raw
In response to jit and explain nontext  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
On 2020-11-20 17:16, Justin Pryzby wrote:
> It matters if it was planned with jit but executed without jit.
> 
> postgres=# DEALLOCATE p; SET jit=on; SET jit_above_cost=0; prepare p as select from generate_series(1,9);
explain(formatyaml) execute p; SET jit=off; explain(format yaml) execute p;
 
> 
> Patched shows this for both explains:
>     JIT:                              +
>       Functions: 3                    +
> 
> Unpatched shows only in the first case.

In this context, I don't see the point of this change.  If you set 
jit=off explicitly, then there is no need to clutter the EXPLAIN output 
with a bunch of zeroes about JIT.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [doc] improve tableoid description
Next
From: Andy Fan
Date:
Subject: Re: Different results between PostgreSQL and Oracle for "for update" statement