| Aggregate (cost=143.36..143.37 rows=1 width=32) |
| -> Hash Join (cost=70.65..143.33 rows=9 width=6) |
| Hash Cond: (t.purchase_contract_id = t_1.id) |
| -> Seq Scan on tbl_erp_collect_tickets t (cost=0.00..67.09 rows=2133 width=10) |
| Filter: ((created_at < '2025-12-23 10:37:28+08'::timestamp with time zone) AND (status = 2)) |
| -> Hash (cost=70.54..70.54 rows=9 width=4) |
| -> Seq Scan on tbl_purchase_contracts t_1 (cost=0.00..70.54 rows=9 width=4) |
| Filter: ((NOT is_draft) AND (NOT is_refuse) AND is_chargeback AND (created_at < '2025-12-23 10:37:28+08'::timestamp with time zone)) |