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?.
7 rows affected
fruit_id | name1 | name2 | rating1 | rating2 | delivered_on | rush_order |
---|---|---|---|---|---|---|
1 | Apple | Banana | 5 | 4 | 2015-10-01 | yes |
2 | Pear | Banana | 3 | 4 | 2015-10-27 | yes |
3 | Apple | Pear | 5 | 4 | 2015-10-29 | no |
4 | Banana | Apple | 2 | 5 | 2015-11-27 | yes |
5 | Banana | Apple | 4 | 1 | 2015-11-29 | yes |
6 | Apple | Banana | 4 | 2 | 2015-12-02 | no |
7 | Pear | Apple | 3 | 5 | 2015-12-20 | yes |
fruit_id | column_id | name | rating | delivered_on | rush_order |
---|---|---|---|---|---|
1 | 1 | Apple | 5 | 2015-10-01 | yes |
1 | 2 | Banana | 4 | 2015-10-01 | yes |
2 | 1 | Pear | 3 | 2015-10-27 | yes |
2 | 2 | Banana | 4 | 2015-10-27 | yes |
3 | 1 | Apple | 5 | 2015-10-29 | no |
3 | 2 | Pear | 4 | 2015-10-29 | no |
4 | 1 | Banana | 2 | 2015-11-27 | yes |
4 | 2 | Apple | 5 | 2015-11-27 | yes |
5 | 1 | Banana | 4 | 2015-11-29 | yes |
5 | 2 | Apple | 1 | 2015-11-29 | yes |
6 | 1 | Apple | 4 | 2015-12-02 | no |
6 | 2 | Banana | 2 | 2015-12-02 | no |
7 | 1 | Pear | 3 | 2015-12-20 | yes |
7 | 2 | Apple | 5 | 2015-12-20 | yes |
fruit_id | column_id | name | rating | delivered_on | rush_order | num |
---|---|---|---|---|---|---|
1 | 1 | Apple | 5 | 2015-10-01 | yes | 1 |
3 | 1 | Apple | 5 | 2015-10-29 | no | 1 |
4 | 2 | Apple | 5 | 2015-11-27 | yes | 2 |
5 | 2 | Apple | 1 | 2015-11-29 | yes | 3 |
6 | 1 | Apple | 4 | 2015-12-02 | no | 3 |
7 | 2 | Apple | 5 | 2015-12-20 | yes | 4 |
1 | 2 | Banana | 4 | 2015-10-01 | yes | 1 |
2 | 2 | Banana | 4 | 2015-10-27 | yes | 2 |
4 | 1 | Banana | 2 | 2015-11-27 | yes | 3 |
5 | 1 | Banana | 4 | 2015-11-29 | yes | 4 |
6 | 2 | Banana | 2 | 2015-12-02 | no | 4 |
2 | 1 | Pear | 3 | 2015-10-27 | yes | 1 |
3 | 2 | Pear | 4 | 2015-10-29 | no | 1 |
7 | 1 | Pear | 3 | 2015-12-20 | yes | 2 |
fruit_id | column_id | name | rating | delivered_on | rush_order | num | sum_rating |
---|---|---|---|---|---|---|---|
1 | 1 | Apple | 5 | 2015-10-01 | yes | 1 | 5 |
3 | 1 | Apple | 5 | 2015-10-29 | no | 1 | 5 |
4 | 2 | Apple | 5 | 2015-11-27 | yes | 2 | 10 |
5 | 2 | Apple | 1 | 2015-11-29 | yes | 3 | 6 |
6 | 1 | Apple | 4 | 2015-12-02 | no | 3 | 6 |
7 | 2 | Apple | 5 | 2015-12-20 | yes | 4 | 6 |
1 | 2 | Banana | 4 | 2015-10-01 | yes | 1 | 4 |
2 | 2 | Banana | 4 | 2015-10-27 | yes | 2 | 8 |
4 | 1 | Banana | 2 | 2015-11-27 | yes | 3 | 6 |
5 | 1 | Banana | 4 | 2015-11-29 | yes | 4 | 6 |
6 | 2 | Banana | 2 | 2015-12-02 | no | 4 | 6 |
2 | 1 | Pear | 3 | 2015-10-27 | yes | 1 | 3 |
3 | 2 | Pear | 4 | 2015-10-29 | no | 1 | 3 |
7 | 1 | Pear | 3 | 2015-12-20 | yes | 2 | 6 |
fruit_id | name1 | name2 | rating1 | rating2 | delivered_on | rush_order | fruit1_rating | fruit2_rating |
---|---|---|---|---|---|---|---|---|
1 | Apple | Banana | 5 | 4 | 2015-10-01 | yes | 5 | 4 |
2 | Pear | Banana | 3 | 4 | 2015-10-27 | yes | 3 | 8 |
3 | Apple | Pear | 5 | 4 | 2015-10-29 | no | 5 | 3 |
4 | Banana | Apple | 2 | 5 | 2015-11-27 | yes | 6 | 10 |
5 | Banana | Apple | 4 | 1 | 2015-11-29 | yes | 6 | 6 |
6 | Apple | Banana | 4 | 2 | 2015-12-02 | no | 6 | 6 |
7 | Pear | Apple | 3 | 5 | 2015-12-20 | yes | 6 | 6 |