Thank you for the incredibly helpful (and fast) replies Peter.
> Attached is its output when I run your test query. The issue here is
that skip scan thinks that there are 4 distinct skip array values that
it must use:
1. SK_BT_MINVAL
2. false
3. true
4. SK_ISNULL
This output in particul
Hi folks,
I'm trying to understand the new Index Searches field in Postgres 18
explain analyze output. I've put together a super simple test case (below)
expecting a skip scan with 2 Index Searches, one for each value in the
leading (boolean) column of the index.
In reality, instead of 2 Index Se
>
> 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
