| Aggregate (cost=172.34..172.35 rows=1 width=32) |
| -> Hash Join (cost=96.17..167.29 rows=2016 width=6) |
| Hash Cond: (t.purchase_contract_id = t_1.id) |
| -> Seq Scan on tbl_erp_payment_tickets t (cost=0.00..65.71 rows=2056 width=10) |
| Filter: (is_payment_settle AND (created_at < '2025-08-08 14:34:58+08'::timestamp with time zone) AND (status = 2)) |
| -> Hash (cost=69.85..69.85 rows=2106 width=4) |
| -> Seq Scan on tbl_purchase_contracts t_1 (cost=0.00..69.85 rows=2106 width=4) |
| Filter: ((NOT is_draft) AND (NOT is_refuse) AND (NOT is_chargeback) AND (created_at < '2025-08-08 14:34:58+08'::timestamp with time zone)) |