| Aggregate (cost=104.18..104.19 rows=1 width=8) |
| -> Sort (cost=95.90..97.28 rows=552 width=238) |
| Sort Key: r.created_at DESC |
| -> HashAggregate (cost=65.24..70.76 rows=552 width=238) |
| Group Key: r.id |
| -> Hash Right Join (cost=25.27..61.04 rows=1681 width=12) |
| Hash Cond: (rvr.erp_ticket_change_log_id = r.id) |
| -> Seq Scan on tbl_erp_ticket_change_log_handlers rvr (cost=0.00..30.40 rows=2040 width=4) |
| -> Hash (cost=18.38..18.38 rows=552 width=12) |
| -> Seq Scan on tbl_erp_ticket_change_logs r (cost=0.00..18.38 rows=552 width=12) |
| Filter: (created_by = 1001) |