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?.
word_permutations |
---|
ABCD |
A BCD |
AB CD |
A B CD |
ABC D |
A BC D |
AB C D |
A B C D |
word_permutations_yper |
---|
ABCD |
AB CD |
A BCD |
A B CD |
ABC D |
AB C D |
A BC D |
A B C D |
word_permutations2 |
---|
ABCD |
AB CD |
A BCD |
A B CD |
ABC D |
AB C D |
A BC D |
A B C D |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=32768 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.012 ms |
Execution Time: 27.925 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=32768 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.025 ms |
Execution Time: 10.949 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=32768 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.019 ms |
Execution Time: 11.564 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=65536 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.019 ms |
Execution Time: 60.356 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=65536 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.028 ms |
Execution Time: 28.819 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=65536 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.027 ms |
Execution Time: 27.761 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=1048576 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.036 ms |
Execution Time: 1014.899 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=1048576 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.029 ms |
Execution Time: 420.173 ms |
QUERY PLAN |
---|
ProjectSet (cost=0.00..5.27 rows=1000 width=32) (actual rows=1048576 loops=1) |
-> Result (cost=0.00..0.01 rows=1 width=0) (actual rows=1 loops=1) |
Planning Time: 0.028 ms |
Execution Time: 407.697 ms |