| GroupAggregate (cost=212.14..212.18 rows=2 width=36) |
| Group Key: (CASE WHEN (project.id IS NOT NULL) THEN project.created_by ELSE contract.created_by END) |
| -> Sort (cost=212.14..212.14 rows=2 width=10) |
| Sort Key: (CASE WHEN (project.id IS NOT NULL) THEN project.created_by ELSE contract.created_by END) |
| -> Nested Loop Left Join (cost=0.28..212.13 rows=2 width=10) |
| Filter: (CASE WHEN (project.id IS NOT NULL) THEN project.created_by ELSE contract.created_by END = ANY ('{5500,5499,5332,1001,5087,5467,5300,5311,5295,1013,5476,1004,1005,5449}'::integer[])) |
| -> Seq Scan on tbl_sales_contracts contract (cost=0.00..76.98 rows=22 width=14) |
| Filter: (COALESCE(need_analysis, true) AND (signed_at >= '2026-01-01'::date) AND (signed_at <= '2026-12-31'::date)) |
| -> Index Scan using tbl_projects_pkey on tbl_projects project (cost=0.28..6.12 rows=1 width=8) |
| Index Cond: (id = contract.from_project) |