QUERY PLAN
Append (cost=0.00..26.24 rows=2 width=198)
-> 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 = 1) AND ((amount - all_paid_amount) > '0'::numeric))
-> Seq Scan on tbl_erp_other_collect_tickets (cost=0.00..13.01 rows=1 width=198)
Filter: ((status = 2) AND (client_id = 1) AND ((amount - all_settle_amount) > '0'::numeric))