| Aggregate (cost=32.12..32.13 rows=1 width=32) |
| -> Nested Loop (cost=0.00..32.11 rows=1 width=32) |
| Join Filter: (r.erp_cash_cost_ticket_id = t.id) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_sales_contract_settles r (cost=0.00..19.38 rows=4 width=36) |
| Filter: (sales_contract_id = 8) |
| -> Materialize (cost=0.00..12.62 rows=2 width=4) |
| -> Seq Scan on tbl_erp_cash_cost_tickets t (cost=0.00..12.61 rows=2 width=4) |
| Filter: (is_payment_settle AND (status = ANY ('{1,2,5}'::integer[]))) |