QUERY PLAN
GroupAggregate (cost=381.90..383.36 rows=45 width=53)
Group Key: pt.product_type_id, pt.name
-> Sort (cost=381.90..382.01 rows=45 width=26)
Sort Key: pt.product_type_id, pt.name
-> Hash Join (cost=306.09..380.66 rows=45 width=26)
Hash Cond: (pt.project_id = tbl_projects.id)
-> Seq Scan on tbl_project_product_types pt (cost=0.00..65.50 rows=3450 width=30)
-> Hash (cost=305.61..305.61 rows=39 width=4)
-> Seq Scan on tbl_projects (cost=0.00..305.61 rows=39 width=4)
Filter: ((bargain_date >= '2025-01-01'::date) AND (bargain_date < '2026-01-01 00:00:00'::timestamp without time zone) AND (bargain_date >= '2025-01-01'::date) AND (bargain_date < '2026-01-01 00:00:00'::timestamp without time zone) AND (project_status = 3) AND (created_by = ANY ('{1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420,5448,5449}'::integer[])) AND (created_by = ANY ('{5329,5332,5448,5420,1001,5087,5300,5311,5295,1013,1004,1005,5449}'::integer[])))