| Aggregate (cost=117.19..117.20 rows=1 width=8) |
| -> Sort (cost=107.19..108.86 rows=667 width=238) |
| Sort Key: r.created_at DESC |
| -> HashAggregate (cost=69.23..75.90 rows=667 width=238) |
| Group Key: r.id |
| -> Hash Right Join (cost=28.39..64.15 rows=2031 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=20.05..20.05 rows=667 width=12) |
| -> Seq Scan on tbl_erp_ticket_change_logs r (cost=0.00..20.05 rows=667 width=12) |
| Filter: ((created_at >= '2025-01-01 00:00:00+08'::timestamp with time zone) AND (created_at <= '2025-12-31 23:59:59+08'::timestamp with time zone)) |