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 1
INSERT 0 1
INSERT 0 1
| gal | m1 | m2 | m3 | m4 | m5 | m6 | m7 | m8 | m9 | m10 | m11 | m12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 小島南 | 5632 | 3508 | 4767 | 2976 | 10722 | 3256 | 8357 | 1094 | 3617 | 6523 | 5731 | 8747 |
| 佐山愛 | 3234 | 10219 | 8861 | 9389 | 9835 | 8251 | 5770 | 10341 | 10624 | 6875 | 3426 | 2937 |
| 小花暖 | 8219 | 5467 | 4453 | 1839 | 10604 | 10174 | 6401 | 5775 | 1203 | 10334 | 9901 | 3890 |
SELECT 3
| gal | greatest |
|---|---|
| 小島南 | 10722 |
| 佐山愛 | 10624 |
| 小花暖 | 10604 |
SELECT 3