| Aggregate (cost=75.99..76.00 rows=1 width=8) |
| -> Sort (cost=67.32..68.77 rows=578 width=238) |
| Sort Key: r.created_at DESC |
| -> HashAggregate (cost=35.03..40.81 rows=578 width=238) |
| Group Key: r.id |
| -> Hash Right Join (cost=24.01..33.58 rows=578 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..8.20 rows=520 width=4) |
| -> Hash (cost=16.78..16.78 rows=578 width=12) |
| -> Seq Scan on tbl_erp_ticket_change_logs r (cost=0.00..16.78 rows=578 width=12) |