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?.
CREATE TABLE
INSERT 0 3
id cost_1 quantity_1 cost_2 quantity_2 total_1 total_2 total_3
1 1 2 3 4 2 12 14
2 3 5 7 9 15 63 78
3 10 5 20 2 50 40 90
SELECT 3