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 | fract_order_suma | fract_agreement_total | wrong_order_suma | order_suma | wrong_agreement_total | xid | agg | prev | _distinct | xorder_suma | correct_total_suma | also_correct_total_suma |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 1.0049 | 3.0147 | 5.0253 | 3.00 | 3.01 | 5.03 | 1 | {1,2,3} | null | t | 3.01 | 5.02 | 5.02 |
2 | 1 | 1 | 1.0049 | 3.0147 | 5.0253 | 3.00 | 3.01 | 5.03 | 2 | {1,2,3} | {1,2,3} | f | 3.01 | 5.02 | 5.02 |
3 | 1 | 1 | 1.0049 | 3.0147 | 5.0253 | 3.00 | 3.01 | 5.03 | 3 | {1,2,3} | {1,2,3} | f | 3.01 | 5.02 | 5.02 |
4 | 1 | 2 | 1.0049 | 2.0106 | 5.0253 | 2.01 | 2.01 | 5.03 | 4 | {4,5} | {1,2,3} | t | 2.01 | 5.02 | 5.02 |
5 | 1 | 2 | 1.0057 | 2.0106 | 5.0253 | 2.01 | 2.01 | 5.03 | 5 | {4,5} | {4,5} | f | 2.01 | 5.02 | 5.02 |
6 | 2 | 1 | 1.53 | 3.71 | 7.19 | 3.71 | 3.71 | 7.19 | 6 | {6,7} | null | t | 3.71 | 7.19 | 7.19 |
7 | 2 | 1 | 2.18 | 3.71 | 7.19 | 3.71 | 3.71 | 7.19 | 7 | {6,7} | {6,7} | f | 3.71 | 7.19 | 7.19 |
8 | 2 | 2 | 3.48 | 3.48 | 7.19 | 3.48 | 3.48 | 7.19 | 8 | {8} | {6,7} | t | 3.48 | 7.19 | 7.19 |
SELECT 8