The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/multivariate-statistics-examples.html Description:
CREATE STATISTICS stts (dependencies) ON a, b FROM t; ANALYZE t; EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1; QUERY PLAN ------------------------------------------------------------------------------- Seq Scan on t (cost=0.00..195.00 rows=100 width=8) (actual rows=100 loops=1) Filter: ((a = 1) AND (b = 1)) Rows Removed by Filter: 9900 The result of the explain is a copy paste of previous example, so this example looks like the statistic doesn't improve things