QUERY PLAN
Append (cost=0.00..4.06 rows=3 width=110)
-> Seq Scan on tbl_erp_advance_payment_tickets (cost=0.00..1.07 rows=1 width=109)
Filter: (is_payment_settle AND (status = 2) AND (supplier_id = 431) AND ((amount - all_paid_amount) > '0'::numeric))
-> Seq Scan on tbl_erp_other_collect_tickets (cost=0.00..2.96 rows=2 width=110)
Filter: ((status = 2) AND (supplier_id = 431) AND ((amount - all_settle_amount) > '0'::numeric))