QUERY PLAN
Aggregate (cost=147.12..147.13 rows=1 width=32)
-> Hash Join (cost=68.64..147.08 rows=17 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=2026 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=68.46..68.46 rows=14 width=4)
-> Seq Scan on tbl_sales_contracts t_1 (cost=0.00..68.46 rows=14 width=4)
Filter: (build_by_project AND (NOT need_analysis) AND (created_at < '2025-08-08 14:34:58+08'::timestamp with time zone))