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?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
id_product | name_product | ingredient_id | product_id_comp | level_blend | last_comp_blend | compact_flat_view |
---|---|---|---|---|---|---|
1 | milk | 1A | 1 | t | CF | |
2 | flour | 2A | 1 | t | CF | |
3 | egs | 3A | 1 | t | CF | |
4 | sugar | 4A | 1 | t | CF | |
5 | salt | 5A | 1 | t | CF | |
8 | bakingsoda | 8A | 1 | t | CF | |
6 | cakeA | 1A | 1B | 1 | t | CF |
6 | cakeA | 6A | 5A | 1 | f | C |
6 | cakeA | 6A | 1A | 1 | f | C |
6 | cakeA | 6B | 2A | 1 | f | C |
7 | cakeB | 7A | 2A | 1 | f | C |
7 | cakeB | 7B | 8A | 1 | f | C |
7 | cakeB | 7C | 3A | 1 | f | C |
5 | cakeA | 6A | 2 | t | F | |
6 | cakeA | 6A | 1B | 2 | t | F |
1 | cakeA | 6A | 2 | t | F | |
2 | cakeA | 6B | 2 | t | F | |
2 | cakeB | 7A | 2 | t | F | |
8 | cakeB | 7B | 2 | t | F | |
3 | cakeB | 7C | 2 | t | F |