By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
version |
---|
PostgreSQL 14.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit |
doc_id | document |
---|---|
1 | {"user_removed": false} |
10000 rows affected
400 rows affected
QUERY PLAN |
---|
Seq Scan on test101 (cost=0.00..218.01 rows=10297 width=40) (actual time=2.040..2.128 rows=400 loops=1) |
Filter: ((document ? 'user_removed'::text) IS FALSE) |
Rows Removed by Filter: 10001 |
Planning Time: 0.417 ms |
Execution Time: 2.199 ms |