add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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