Re: BUG #15722: 9000x performance regression on query starting PostgreSQL 10 due to bad query plan

On Tue, Apr 2, 2019 at 10:11 AM Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

> On Fri, Mar 29, 2019 at 6:53 AM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>>
>> The following files are available at
>> https://gist.github.com/jeremyevans/8a9693b1d3f14c94f635b1bf4275b2be
>>
>>
> Could you also include the human readable explain plans (even just for
> 9.6. and 10)? JSON objects with 1900 lines might be good for machines, but
> not for people. (Of course the human readable format might not be all that
> readable either, but it is worth a shot)
>
> Cheers,
>
> Jeff
>

Jeff,

Sorry for the delay, it took a while to rerun the query on 10. I've
updated the gist to add plain text query plans for 9.6 and 10:

9.6:
https://gist.github.com/jeremyevans/8a9693b1d3f14c94f635b1bf4275b2be#file-explain-9-6-txt
10:
https://gist.github.com/jeremyevans/8a9693b1d3f14c94f635b1bf4275b2be#file-explain-10-txt

If you would like the query plans for 9.3-9.5 or 11, please let me know.
Also, here are links to explain.depesz.com for both query plans:

9.6: https://explain.depesz.com/s/LfEk
10: https://explain.depesz.com/s/lTf

I originally thought the JSON plans would be more useful, using a viewer
such as http://tatiyants.com/pev, that is why I didn't include plain text
plans when submitting the bug report.

Thanks,
Jeremy