| Aggregate (cost=172.73..172.74 rows=1 width=32) |
| -> Hash Join (cost=88.60..167.40 rows=2131 width=6) |
| Hash Cond: (t.sales_contract_id = t_1.id) |
| -> Seq Scan on tbl_erp_payment_tickets t (cost=0.00..73.12 rows=2165 width=10) |
| Filter: (is_payment_settle AND (created_at < '2025-12-23 10:37:28+08'::timestamp with time zone) AND (status = 2)) |
| -> Hash (cost=68.46..68.46 rows=1611 width=4) |
| -> Seq Scan on tbl_sales_contracts t_1 (cost=0.00..68.46 rows=1611 width=4) |
| Filter: (build_by_project AND need_analysis AND (created_at < '2025-12-23 10:37:28+08'::timestamp with time zone)) |