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?.
10000 rows affected
QUERY PLAN |
---|
Bitmap Heap Scan on foo (cost=13.01..323.85 rows=99 width=1008) (actual time=0.059..1.182 rows=100 loops=1) |
Recheck Cond: ((bar >= 1) AND (bar <= 100)) |
Rows Removed by Index Recheck: 796 |
Heap Blocks: lossy=128 |
-> Bitmap Index Scan on foo_brin (cost=0.00..12.99 rows=99 width=0) (actual time=0.042..0.043 rows=1280 loops=1) |
Index Cond: ((bar >= 1) AND (bar <= 100)) |
Planning time: 0.124 ms |
Execution time: 1.210 ms |