public inbox for [email protected]
help / color / mirror / Atom feedFrom: Igor Kustov <[email protected]>
To: [email protected] <[email protected]>
Subject: default cardinality with non-existent value
Date: Fri, 25 Apr 2025 12:35:39 +0300
Message-ID: <[email protected]> (raw)
<div>hello all,</div><div> </div><div>I noticed that the optimizer expects one row when there is a condition on the field for which optimizer does not know the value based on statistics, e.g.</div><div> </div><div><div>postgres=# create table t1 (a int, b int);</div><div>CREATE TABLE</div><div>postgres=# insert into t1 values (generate_series(1,1000),1);</div><div>INSERT 0 1000</div><div>and so on...</div><div>postgres=# insert into t1 values (generate_series(4001,5000),5);</div><div>INSERT 0 1000</div><div>postgres=# analyze t1;</div><div>ANALYZE</div><div>postgres=# explain select * from t1 where b=5;</div><div> QUERY PLAN</div><div>------------------------------------------------------</div><div> Seq Scan on t1 (cost=0.00..85.50 rows=1000 width=8)</div><div> Filter: (b = 5)</div><div>(2 rows)</div><div> </div><div>postgres=# explain select * from t1 where b=6;</div><div> QUERY PLAN</div><div>---------------------------------------------------</div><div> Seq Scan on t1 (cost=0.00..85.50 rows=1 width=8)</div><div> Filter: (b = 6)</div><div>(2 rows)</div><div> </div><div>do you know if there is a formula for such a cardinality based on the size of the table or is it always one row?</div><div>can you point to the source code location?</div><div> </div><div>Thanks,</div><div>Igor</div></div>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: default cardinality with non-existent value
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox