| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | david(dot)emmerson(at)gearset(dot)com |
| Subject: | Copy paste error |
| Date: | 2025-02-13 11:39:15 |
| Message-ID: | 173944675534.197401.3845582322444390962@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2025-02-13 14:49:07 | Re: Copy paste error |
| Previous Message | David G. Johnston | 2025-02-12 21:51:38 | Re: incorrect error message |