Re: Is there something wrong with my test case?

Hi Fabio

Quoting Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>:

> The cost is not a range. The 2 numbers you see are:
>
>
> *
> Estimated start-up cost. This is the time expended before the
> output phase can begin, e.g., time to do the sorting in a sort node.
>
> * Estimated total cost. This is stated on the assumption that
> the plan node is run to completion, i.e., all available rows are
> retrieved. In practice a node's parent node might stop short of
> reading all available rows (see the LIMIT example below).
>
> As you can read here:
>
> https://www.postgresql.org/docs/current/using-explain.html

Thanks for pointing this out. I was mislead than be the form those two
different things are displayed.
--
Signal: +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id:
B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B