QUERY PLAN
Hash Join (cost=83.91..149.92 rows=22 width=62)
Hash Cond: (t.id = r.erp_collect_ticket_id)
-> Seq Scan on tbl_erp_collect_tickets t (cost=0.00..58.24 rows=2015 width=4)
Filter: (status = ANY ('{2,5}'::integer[]))
-> Hash (cost=83.63..83.63 rows=22 width=62)
-> Seq Scan on tbl_erp_collect_ticket_settles r (cost=0.00..83.63 rows=22 width=62)
Filter: (erp_other_collect_ticket_id = ANY ('{36,35,34,33,32,31,30,29,28,27,26,15,14,13,12,11,10,9,8,7}'::integer[]))