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?.
setseed |
---|
SELECT 1
CREATE TABLE
INSERT 0 200000
CREATE INDEX
CREATE INDEX
CREATE INDEX
VACUUM
QUERY PLAN |
---|
Limit (cost=0.00..748971.00 rows=426 width=59) (actual time=17860.388..17860.396 rows=0 loops=1) |
Output: id, created_at, name |
-> Seq Scan on public.products (cost=0.00..748971.00 rows=426 width=59) (actual time=14737.176..14737.180 rows=0 loops=1) |
Output: id, created_at, name |
Filter: (products.id = ANY (ARRAY[(random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text, (random())::text])) |
Rows Removed by Filter: 200000 |
Planning Time: 0.766 ms |
JIT: |
Functions: 4 |
Options: Inlining true, Optimization true, Expressions true, Deforming true |
Timing: Generation 10.014 ms, Inlining 79.153 ms, Optimization 1034.406 ms, Emission 2009.637 ms, Total 3133.210 ms |
Execution Time: 17999.320 ms |
EXPLAIN