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