QUERY PLAN
Append (cost=0.00..16.12 rows=2 width=154)
-> Seq Scan on tbl_erp_advance_payment_tickets (cost=0.00..13.21 rows=1 width=198)
Filter: (is_payment_settle AND (status = 2) AND (client_id = 3303) AND ((amount - all_paid_amount) > '0'::numeric))
-> Seq Scan on tbl_erp_other_collect_tickets (cost=0.00..2.89 rows=1 width=110)
Filter: ((status = 2) AND (client_id = 3303) AND ((amount - all_settle_amount) > '0'::numeric))