QUERY PLAN
Append (cost=0.00..13.96 rows=2 width=198)
-> Seq Scan on tbl_erp_advance_payment_tickets (cost=0.00..12.71 rows=1 width=198)
Filter: ((un_paid_amount > '0'::numeric) AND (client_id = 3389))
-> Seq Scan on tbl_erp_other_collect_tickets (cost=0.00..1.24 rows=1 width=198)
Filter: ((client_id = 3389) AND ((amount - settle_amount) > '0'::numeric))