Re: Should from_collapse be switched off? (queries 10 times faster)

2018-03-26 Thread Laurenz Albe
Peter wrote: > ! Your reported execution times don't match the time reported in the > ! EXPLAIN output... > > Should these match? > It seems the EXPLAIN (ANALYZE, BUFFERS) does additional things, not > just execute the query. True. I had assumed you were speaking about the duration of the EXPLA

Re: Should from_collapse be switched off? (queries 10 times faster)

2018-03-26 Thread Peter
Laurenz, thank You very much for Your comments! On Sun, Mar 25, 2018 at 07:12:08AM +0200, Laurenz Albe wrote: ! Your reported execution times don't match the time reported in the ! EXPLAIN output... Should these match? It seems the EXPLAIN (ANALYZE, BUFFERS) does additional things, not just e