| Aggregate (cost=122.59..122.60 rows=1 width=8) |
| -> Sort (cost=122.05..122.14 rows=36 width=285) |
| Sort Key: sub.created_at |
| -> Subquery Scan on sub (cost=0.00..121.12 rows=36 width=285) |
| -> Append (cost=0.00..120.76 rows=36 width=285) |
| -> Subquery Scan on "*SELECT* 1" (cost=0.00..1.16 rows=5 width=217) |
| -> Seq Scan on tbl_purchase_contracts r (cost=0.00..1.10 rows=5 width=215) |
| Filter: ((NOT is_draft) AND (NOT is_refuse) AND (erp_un_settle_amount > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 2" (cost=0.00..12.82 rows=1 width=335) |
| -> Seq Scan on tbl_erp_advance_payment_tickets r_1 (cost=0.00..12.81 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 3" (cost=0.00..12.82 rows=1 width=335) |
| -> Seq Scan on tbl_erp_other_payment_tickets r_2 (cost=0.00..12.81 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 4" (cost=0.00..14.07 rows=1 width=335) |
| -> Seq Scan on tbl_erp_cost_tickets r_3 (cost=0.00..14.06 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 5" (cost=0.00..13.70 rows=1 width=335) |
| -> Seq Scan on tbl_erp_wage_tickets r_4 (cost=0.00..13.69 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 6" (cost=0.00..13.70 rows=1 width=335) |
| -> Seq Scan on tbl_erp_social_insurances r_5 (cost=0.00..13.69 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 7" (cost=0.00..13.70 rows=1 width=335) |
| -> Seq Scan on tbl_erp_provident_funds r_6 (cost=0.00..13.69 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 8" (cost=0.00..13.70 rows=1 width=335) |
| -> Seq Scan on tbl_erp_personal_taxs r_7 (cost=0.00..13.69 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 9" (cost=0.00..13.70 rows=1 width=335) |
| -> Seq Scan on tbl_erp_wage_prizes r_8 (cost=0.00..13.69 rows=1 width=333) |
| Filter: ((status = 2) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Seq Scan on tbl_sales_contracts r_9 (cost=0.00..11.16 rows=23 width=527) |
| Filter: (erp_un_settle_amount < '0'::numeric) |