| Aggregate (cost=278.14..278.15 rows=1 width=32) |
| -> Hash Left Join (cost=202.45..274.67 rows=1385 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=178.31..178.31 rows=1931 width=8) |
| -> Seq Scan on tbl_clients c (cost=0.00..178.31 rows=1931 width=8) |