Hi .
Ive just created an account as Patrick83300.
The Count_Estimate Wiki Page seems wrong and id like to change few things :
The example create table has 1000 rows and not 100 :) ,
generate_series(1,1000) makes 1000 numbers, not 100 (at least in
Postgres 9.5.3)
One should use a «explain select ... where t<999999999999» in order to
get the actual number of rows in the "rows=" part of the plan.
explain select * from tbl where t<2222;
QUERY PLAN
....... rows=1000
Filter: (t < 2222)
If one use t<100 he gets rows=100 which is not an estimation of the
TOTAL number of rows in the table.
Cordialement.
Patrick BUNINO