Re: Is there something wrong with my test case?
От | Thiemo Kellner |
---|---|
Тема | Re: Is there something wrong with my test case? |
Дата | |
Msg-id | 20190107120644.Horde.l9BLrQ2kzVh6KFqM5N7vij8@webmail.gelassene-pferde.biz обсуждение исходный текст |
Ответ на | Re: Is there something wrong with my test case? (Fabio Pardi <f.pardi@portavita.eu>) |
Список | pgsql-general |
Hi Fabio Quoting Fabio Pardi <f.pardi@portavita.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
В списке pgsql-general по дате отправления: