QUERY PLAN
Limit (cost=390.82..390.85 rows=14 width=250)
-> Sort (cost=390.82..390.85 rows=14 width=250)
Sort Key: r.created_at DESC
-> Group (cost=390.48..390.55 rows=14 width=250)
Group Key: r.id
-> Sort (cost=390.48..390.52 rows=14 width=250)
Sort Key: r.id
-> Hash Right Join (cost=366.81..390.22 rows=14 width=250)
Hash Cond: (rvr.erp_collect_ticket_id = r.id)
-> Seq Scan on tbl_erp_collect_ticket_verify_rels rvr (cost=0.00..19.70 rows=970 width=4)
-> Hash (cost=366.63..366.63 rows=14 width=250)
-> Hash Left Join (cost=323.32..366.63 rows=14 width=250)
Hash Cond: (ectss.sales_contract_id = s.id)
Filter: (s.project_id IS NULL)
-> Hash Right Join (cost=76.69..114.77 rows=1986 width=254)
Hash Cond: (ectss.erp_collect_ticket_id = r.id)
-> Seq Scan on tbl_erp_collect_ticket_settles ectss (cost=0.00..32.86 rows=1986 width=8)
-> Hash (cost=51.86..51.86 rows=1986 width=250)
-> Seq Scan on tbl_erp_collect_tickets r (cost=0.00..51.86 rows=1986 width=250)
-> Hash (cost=226.84..226.84 rows=1584 width=8)
-> Seq Scan on tbl_sales_contracts s (cost=0.00..226.84 rows=1584 width=8)