[resent to the list, sorry Alvaro]
Hello,
On 5 December 2017 at 13:39, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> it seems pretty likely that these are indeed overflows. However,
> because of the whitespace mangling these plans are pretty much
> impossible to read. Would you mind pasting these again, as text/plain
> attachment instead?
I attached the plans in plain text.
> Does the query actually take 6ms in the system with the funny explain,
> and 5s on the other?
I didn't really noticed the timings, could be. I was more surprised
that the broken plan actually resulted in zero rows because it should
have had some.
Kind regards,
Jan
--
Jan Schulz
mail: jasc@gmx.net