QUERY PLAN
Sort (cost=48.79..48.79 rows=1 width=35)
Sort Key: collected_date, created_at
-> Seq Scan on tbl_purchase_contract_payments (cost=0.00..48.78 rows=1 width=35)
Filter: ((amount > '0'::numeric) AND (amount > paid_amount) AND (contract_id = 3847))