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 6
ordrnbr vehiclename description id totprice
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000
135 toyota abc@21000@bsd@2300 2aqE 23300
138 honda abc@2100 3xDY 2100
141 kia text 6iPQ 10000
145 Mazda null 90ER 9000
147 BMW null 69TY 90000
SELECT 6
ordrnbr vehiclename description id totprice ind_price
132-1 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 21000
132-2 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 23000
132-3 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 41000
135-1 toyota abc@21000@bsd@2300 2aqE 23300 21000
141-1 kia text 6iPQ 10000 10000
147-1 BMW null 69TY 90000 90000
SELECT 6
ordrnbr n nr1 nr2 nkey nval description
132 0 1 2 123 21000 123@21000@bsd@23000@wer@41000
132 1 3 4 bsd 23000 123@21000@bsd@23000@wer@41000
132 2 5 6 wer 41000 123@21000@bsd@23000@wer@41000
135 0 1 2 abc 21000 abc@21000@bsd@2300
135 1 3 4 bsd 2300 abc@21000@bsd@2300
138 0 1 2 abc 2100 abc@2100
141 0 1 1 text null text
145 null null null null null null
147 null null null null null null
SELECT 9
ordrnbr n min max nkey nval sufix
132 0 1 2 123 21000 1
132 1 3 4 bsd 23000 2
132 2 5 6 wer 41000 3
135 0 1 2 abc 21000 1
135 1 3 4 bsd 2300 1
138 0 1 2 abc 2100 0
141 0 1 1 text null 0
145 null null null null null 0
147 null null null null null 0
SELECT 9
ordrnbr vehiclename description id totprice elem nr
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 123 1
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 21000 2
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 bsd 3
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 23000 4
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 wer 5
132 tesla 123@21000@bsd@23000@wer@41000 1saR 84000 41000 6
135 toyota abc@21000@bsd@2300 2aqE 23300 abc 1
135 toyota abc@21000@bsd@2300 2aqE 23300 21000 2
135 toyota abc@21000@bsd@2300 2aqE 23300 bsd 3
135 toyota abc@21000@bsd@2300 2aqE 23300 2300 4
138 honda abc@2100 3xDY 2100 abc 1
138 honda abc@2100 3xDY 2100 2100 2
141 kia text 6iPQ 10000 text 1
145 Mazda null 90ER 9000 null null
147 BMW null 69TY 90000 null null
SELECT 15