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 9
| block_date | address | balance | amount | price | avg_acq_price |
|---|---|---|---|---|---|
| 2023-01-01 | A | 5.00 | 5.00 | 10.00 | 10.00 |
| 2023-01-02 | A | 0.00 | -5.00 | 20.00 | 10.00 |
| 2023-01-03 | A | 8.00 | 8.00 | 30.00 | 30.00 |
| 2023-01-04 | A | 10.00 | 2.00 | 40.00 | 32.00 |
| 2023-01-05 | A | 8.00 | -2.00 | 50.00 | 32.00 |
| 2023-01-06 | A | 15.00 | 7.00 | 60.00 | 45.07 |
| 2023-01-07 | A | 11.00 | -4.00 | 70.00 | 45.07 |
| 2023-01-08 | A | 17.00 | 6.00 | 80.00 | 57.40 |
| 2023-01-09 | A | 26.00 | 9.00 | 90.00 | 68.68 |
SELECT 9