Re: explain with costs in subselect.sql

2018-03-12 Thread Andres Freund
On 2018-03-12 18:25:42 -0400, Tom Lane wrote: > Andres Freund writes: > > When forcing JITing to be enabled for all queries, obviously only useful > > for testing, I noticed that two explain outputs changed after I added > > explain support. > > > The only differences come from: > > > -- Unspeci

Re: explain with costs in subselect.sql

2018-03-12 Thread Tom Lane
Andres Freund writes: > When forcing JITing to be enabled for all queries, obviously only useful > for testing, I noticed that two explain outputs changed after I added > explain support. > The only differences come from: > -- Unspecified-type literals in output columns should resolve as text >

explain with costs in subselect.sql

2018-03-12 Thread Andres Freund
Hi Tom, all, When forcing JITing to be enabled for all queries, obviously only useful for testing, I noticed that two explain outputs changed after I added explain support. The only differences come from: -- Unspecified-type literals in output columns should resolve as text SELECT *, pg_typeof(