| Aggregate (cost=29.30..29.31 rows=1 width=8) |
| -> Sort (cost=29.29..29.29 rows=1 width=238) |
| Sort Key: r.created_at DESC |
| -> Group (cost=29.27..29.28 rows=1 width=238) |
| Group Key: r.id |
| -> Sort (cost=29.27..29.27 rows=1 width=12) |
| Sort Key: r.id |
| -> Hash Right Join (cost=19.68..29.26 rows=1 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=19.67..19.67 rows=1 width=12) |
| -> Seq Scan on tbl_erp_ticket_change_logs r (cost=0.00..19.67 rows=1 width=12) |
| Filter: ((created_at >= '2025-09-19 00:00:00+08'::timestamp with time zone) AND (created_at <= '2025-09-19 23:59:59+08'::timestamp with time zone)) |