add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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