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 EXPLAIN (ANALYZE). > ! Setting "enable_nestloop = off" is as coarse as forcing "from_collapse = 1" > ! and will negatively impact other queries - if it helps at all. > > Since this query is already put into a function, I found I can easily > set from_collapse=1 only for this function, by means of "ALTER > FUNCTION ... SET ...", so it does only influence this query. > It seems this is the most straight-forward solution here. It is an option, although not one that makes one happy. You might have to revisit the decision if the data distribution changes and the chosen query plan becomes inefficient. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
