>
> 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),
>
>
> 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
> > 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
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
