Search Postgresql Archives

Re: Is there something wrong with my test case?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Fabio

Quoting Fabio Pardi <f.pardi@xxxxxxxxxxxx>:

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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux