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?.
4 rows affected
| QUERY PLAN |
|---|
| Aggregate (cost=27794.60..27794.61 rows=1 width=32) (actual time=0.025..0.025 rows=1 loops=1) |
| Buffers: shared hit=2 dirtied=1 |
| -> Nested Loop (cost=0.00..23170.60 rows=1849600 width=0) (actual time=0.008..0.016 rows=16 loops=1) |
| Buffers: shared hit=2 dirtied=1 |
| -> Seq Scan on docs d1 (cost=0.00..23.60 rows=1360 width=0) (actual time=0.004..0.005 rows=4 loops=1) |
| Buffers: shared hit=1 dirtied=1 |
| -> Materialize (cost=0.00..30.40 rows=1360 width=0) (actual time=0.001..0.001 rows=4 loops=4) |
| Buffers: shared hit=1 |
| -> Seq Scan on docs d2 (cost=0.00..23.60 rows=1360 width=0) (actual time=0.001..0.002 rows=4 loops=1) |
| Buffers: shared hit=1 |
| Planning time: 0.089 ms |
| Execution time: 0.058 ms |