Message-ID: <20251001144126.14211k10ws970dx2@monmail.nnx.com>
Date: Wed, 01 Oct 2025 14:41:26 +0200
From: Patrick BUNINO <taijiquan@neuronnexion.fr>
Reply-to: patrickb@nnx.com
To: pgsql-www@postgresql.org
Subject: Wiki Editor request
MIME-Version: 1.0
Content-Type: text/plain;
 charset=ISO-8859-1;
 DelSp="Yes";
 format="flowed"
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
User-Agent: Internet Messaging Program (IMP) H3 (4.3.7)
Archived-At: 
 <https://www.postgresql.org/message-id/20251001144126.14211k10ws970dx2%40monmail.nnx.com>
Precedence: bulk

Hi .
I=92ve just created an account as Patrick83300.

The Count_Estimate Wiki Page seems wrong and i=92d like to change few thing=
s :
The example create table has 1000 rows and not 100 :) , =20
generate_series(1,1000) makes 1000 numbers, not 100 (at least in =20
Postgres 9.5.3)

One should use a =ABexplain select ... where t<999999999999=BB in order to =
=20
get the actual number of rows in the "rows=3D" part of the plan.
explain select * from tbl where t<2222;
QUERY PLAN
....... rows=3D1000
Filter: (t < 2222)

If one use t<100 he gets rows=3D100 which is not an estimation of the =20
TOTAL number of rows in the table.

Cordialement.
Patrick BUNINO