QUERY PLAN
Aggregate (cost=32.55..32.56 rows=1 width=32)
-> Nested Loop (cost=0.00..32.55 rows=1 width=32)
Join Filter: (r.erp_cash_cost_ticket_id = t.id)
-> Seq Scan on tbl_erp_cash_cost_ticket_purchase_contract_settles r (cost=0.00..19.75 rows=4 width=36)
Filter: (purchase_contract_id = 4072)
-> Materialize (cost=0.00..12.63 rows=3 width=4)
-> Seq Scan on tbl_erp_cash_cost_tickets t (cost=0.00..12.61 rows=3 width=4)
Filter: (status = ANY ('{2,5,1}'::integer[]))