Aggregate (cost=201.82..201.83 rows=1 width=32) |
-> Hash Left Join (cost=129.90..198.87 rows=1179 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..64.83 rows=1571 width=10) |
Filter: (need_analysis AND (created_at < '2025-08-05 17:19:26+08'::timestamp with time zone)) |
-> Hash (cost=105.51..105.51 rows=1951 width=8) |
-> Seq Scan on tbl_clients c (cost=0.00..105.51 rows=1951 width=8) |