| HashAggregate (cost=40.60..45.85 rows=350 width=214) |
| Group Key: ci.id |
| -> Hash Left Join (cost=21.41..36.23 rows=350 width=214) |
| Hash Cond: (ci.id = c.client_industry) |
| -> Seq Scan on tbl_client_industries ci (cost=0.00..13.50 rows=350 width=150) |
| -> Hash (cost=21.39..21.39 rows=1 width=68) |
| -> Nested Loop (cost=0.14..21.39 rows=1 width=68) |
| -> Seq Scan on tbl_projects p (cost=0.00..12.47 rows=1 width=68) |
| Filter: ((created_by = ANY ('{5493,5493}'::integer[])) AND (bargain_date >= '2026-01-01'::date) AND (bargain_date <= '2026-12-31'::date) AND (bargain_date >= '2026-01-01'::date) AND (bargain_date < '2027-01-01 00:00:00'::timestamp without time zone)) |
| -> Index Scan using tbl_clients_pkey on tbl_clients c (cost=0.14..8.15 rows=1 width=8) |
| Index Cond: (id = p.client_id) |