| Aggregate (cost=83.49..83.50 rows=1 width=8) |
| -> Append (cost=0.00..83.48 rows=3 width=0) |
| -> Subquery Scan on "*SELECT* 1" (cost=0.00..80.60 rows=1 width=0) |
| -> Seq Scan on tbl_purchase_contracts (cost=0.00..80.59 rows=1 width=434) |
| Filter: ((erp_un_settle_amount > '0'::numeric) AND (cost_type = 1) AND (supplier_id = 431)) |
| -> Subquery Scan on "*SELECT* 3" (cost=0.00..1.21 rows=1 width=0) |
| -> Seq Scan on tbl_erp_cost_tickets (cost=0.00..1.20 rows=1 width=242) |
| Filter: ((status = 2) AND (supplier_id = 431) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Subquery Scan on "*SELECT* 4" (cost=0.00..1.67 rows=1 width=0) |
| -> Seq Scan on tbl_erp_other_payment_tickets (cost=0.00..1.66 rows=1 width=242) |
| Filter: ((status = 2) AND (supplier_id = 431) AND ((amount - settle_amount) > '0'::numeric)) |