QUERY PLAN
Aggregate (cost=206.23..206.24 rows=1 width=32)
-> Hash Left Join (cost=130.92..203.15 rows=1233 width=6)
Hash Cond: (t.client_id = c.id)
Filter: ((c.sales_rep = ANY ('{1001,5087,1005,1004,5295,5300,5311,5332,1013,5449}'::integer[])) OR (c.sales_rep IS NULL))
-> Seq Scan on tbl_sales_contracts t (cost=0.00..67.89 rows=1644 width=10)
Filter: (need_analysis AND (created_at < '2025-08-08 00:00:00+08'::timestamp with time zone))
-> Hash (cost=106.52..106.52 rows=1952 width=8)
-> Seq Scan on tbl_clients c (cost=0.00..106.52 rows=1952 width=8)