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?.
3 rows affected
| serial | opening | int_amount | prncpl_amount | prncpl_os |
|---|---|---|---|---|
| 1 | 100000 | 1200.000 | 1800.000 | 98200.000 |
| 2 | 98200.000 | 1178.400000 | 1821.600000 | 96378.400000 |
| 3 | 96378.400000 | 1156.540800000 | 843.459200000 | 95534.940800000 |