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?.
| id | agreement_id | order_id | suma | nrow | fract_order_suma | fract_agreement_total | wrong_order_suma | order_suma | wrong_agreement_total | xid | agg | sum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1.0049 | 1 | 3.0147 | 5.0253 | 3.00 | 3.01 | 5.03 | 1 | {1,2,3} | 5.02 |
| 2 | 1 | 1 | 1.0049 | 2 | 3.0147 | 5.0253 | 3.00 | 3.01 | 5.03 | 2 | {1,2,3} | 5.02 |
| 3 | 1 | 1 | 1.0049 | 3 | 3.0147 | 5.0253 | 3.00 | 3.01 | 5.03 | 3 | {1,2,3} | 5.02 |
| 4 | 1 | 2 | 1.0049 | 1 | 2.0106 | 5.0253 | 2.01 | 2.01 | 5.03 | 4 | {4,5} | 5.02 |
| 5 | 1 | 2 | 1.0057 | 2 | 2.0106 | 5.0253 | 2.01 | 2.01 | 5.03 | 5 | {4,5} | 5.02 |
| 6 | 2 | 1 | 1.53 | 1 | 3.71 | 7.19 | 3.71 | 3.71 | 7.19 | 6 | {6,7} | 7.19 |
| 7 | 2 | 1 | 2.18 | 2 | 3.71 | 7.19 | 3.71 | 3.71 | 7.19 | 7 | {6,7} | 7.19 |
| 8 | 2 | 2 | 3.48 | 1 | 3.48 | 7.19 | 3.48 | 3.48 | 7.19 | 8 | {8} | 7.19 |
SELECT 8