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?.
SELECT x."id",
x."avgHighPrice",
x."avgLowPrice"
FROM json_to_recordset('[{"avgHighPrice":153,"highPriceVolume":61308,"avgLowPrice":151,"lowPriceVolume":11252,"id":"2"}
,{"avgHighPrice":194920,"highPriceVolume":1,"avgLowPrice":182001,"lowPriceVolume":1,"id":"6"}
,{"avgHighPrice":187121,"highPriceVolume":4,"avgLowPrice":178642,"lowPriceVolume":2,"id":"10"}]')
AS x ("avgHighPrice" INT, "highPriceVolume" INT, "avgLowPrice" INT, "lowPriceVolume" INT, "id" INT);
| id | avgHighPrice | avgLowPrice |
|---|---|---|
| 2 | 153 | 151 |
| 6 | 194920 | 182001 |
| 10 | 187121 | 178642 |
SELECT 3