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?.
26 rows affected
the_letter |
---|
A |
B |
C |
D |
let_a | let_b | the_product |
---|---|---|
A | B | 4290 |
A | C | 4355 |
A | D | 4420 |
A | E | 4485 |
B | C | 4422 |
B | D | 4488 |
the_product | count |
---|---|
5460 | 2 |
5544 | 2 |
5850 | 2 |
6120 | 2 |
6160 | 2 |
6300 | 2 |
6480 | 2 |
let_a | let_b | the_product |
---|---|---|
A | T | 5460 |
F | N | 5460 |
B | T | 5544 |
H | M | 5544 |
A | Z | 5850 |
K | N | 5850 |
D | Z | 6120 |
H | U | 6120 |
F | X | 6160 |
M | P | 6160 |
F | Z | 6300 |
K | T | 6300 |
H | Z | 6480 |
P | Q | 6480 |