> > Anyone here use such a tool for Postgres? Any recommendations?
>>> >
>>> > Say I have 150 queries in Postgres 11 and I want to upgrade to
>>> Postgres 15. I want to run explain analyze for 150 in both versions for
>>> comparative
>>> > analysis.
>>> >
>>> > I am looking for the easiest way to d
>
> Does anyone have a theory of why pg15 should behave so differently to pg11
> here? Better still, any suggestions for configuration that might make pg15
> behave more like pg10. I am really dreading the prospect of stepping our
> many live implementations back to pg11 :-(.
>
One major factor
That plan looks like it might have been cropped in places, and the
formatting is making it tricky to help.
Could you try again, pasting the plan into https://explain.depesz.com/ to
make it easier to review?
On Fri, Apr 3, 2020 at 5:18 PM dangal wrote:
> Justin thank you very much for your answe
>
> CREATE STATISTICS st_simrun_component_metadata (dependencies) ON
> sim_run_id, key FROM sim_run_component_metadata;
> ANALYZE sim_run_component_metadata;
>
> When I run this query, no statistics are returned:
>
> SELECT m.* FROM pg_statistic_ext join pg_statistic_ext_data on (oid =
> stxoid),
>
