QUERY PLAN
Limit (cost=419.53..419.56 rows=10 width=237)
-> Sort (cost=419.53..419.56 rows=10 width=237)
Sort Key: r.created_at DESC
-> Group (cost=419.32..419.37 rows=10 width=237)
Group Key: r.id
-> Sort (cost=419.32..419.34 rows=10 width=237)
Sort Key: r.id
-> Hash Right Join (cost=53.00..419.15 rows=10 width=237)
Hash Cond: (rvr.erp_cash_cost_ticket_id = r.id)
-> Seq Scan on tbl_erp_cash_cost_ticket_verify_rels rvr (cost=0.00..294.58 rows=19058 width=4)
-> Hash (cost=52.95..52.95 rows=4 width=237)
-> Nested Loop (cost=0.28..52.95 rows=4 width=237)
-> Seq Scan on tbl_erp_cash_cost_ticket_purchase_contract_settles eptss (cost=0.00..19.75 rows=4 width=4)
Filter: (purchase_contract_id = 4025)
-> Index Scan using tbl_erp_cash_cost_tickets_pkey on tbl_erp_cash_cost_tickets r (cost=0.28..8.30 rows=1 width=237)
Index Cond: (id = eptss.erp_cash_cost_ticket_id)