Re: Is there something wrong with my test case? - Mailing list pgsql-general

From Thiemo Kellner
Subject Re: Is there something wrong with my test case?
Date
Msg-id 20190107120644.Horde.l9BLrQ2kzVh6KFqM5N7vij8@webmail.gelassene-pferde.biz
Whole thread Raw
In response to Re: Is there something wrong with my test case?  (Fabio Pardi <f.pardi@portavita.eu>)
List 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 by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: Is there something wrong with my test case?
Next
From: Vimal Kanzariya
Date:
Subject: Which queries have run query trace form .exe.