QUERY PLAN
GroupAggregate (cost=690.70..692.17 rows=21 width=148)
Group Key: ex.id, sub.product_type
Filter: (sum(sub.amount) <> '0'::numeric)
-> Sort (cost=690.70..690.75 rows=21 width=116)
Sort Key: ex.id, sub.product_type
-> Hash Right Join (cost=688.43..690.24 rows=21 width=116)
Hash Cond: (ex.id = sub.product_type)
-> Seq Scan on tbl_product_types ex (cost=0.00..1.63 rows=63 width=16)
-> Hash (cost=688.17..688.17 rows=21 width=100)
-> Subquery Scan on sub (cost=687.59..688.17 rows=21 width=100)
-> HashAggregate (cost=687.59..687.96 rows=21 width=100)
Group Key: p.product_type
-> Hash Right Join (cost=635.70..666.37 rows=2122 width=76)
Hash Cond: (ppr.product_id = p.id)
-> HashAggregate (cost=536.95..553.60 rows=1110 width=80)
Group Key: ppr.product_id
-> Hash Join (cost=458.10..511.47 rows=1274 width=18)
Hash Cond: (ppr.project_id = project.id)
-> Seq Scan on tbl_project_product_rels ppr (cost=0.00..48.36 rows=1907 width=22)
Filter: ((amount IS NOT NULL) AND (cost IS NOT NULL) AND (number IS NOT NULL))
-> Hash (cost=431.52..431.52 rows=2126 width=4)
-> Bitmap Heap Scan on tbl_projects project (cost=79.89..431.52 rows=2126 width=4)
Recheck Cond: (created_by = ANY ('{1001,5049,5500,5301,5499,5022,5209,5026,5293,5309,5356,5329,5299,5303,5302,5332,5047,1026,5096,5070,5448,5420,1029,5037,5087,1008,5048,5043,5045,5230,5031,5088,5208,1003,5467,5294,5357,5044,1030,5076,5300,5027,5089,5311,5066,5069,5364,1009,5295,1013,5128,5203,1025,5032,5075,5476,1004,5072,5033,5359,5412,5409,5229,1005,5304,5449,5358,1006,5093}'::integer[]))
-> Bitmap Index Scan on tbl_projects_created_by_idx (cost=0.00..79.36 rows=2126 width=0)
Index Cond: (created_by = ANY ('{1001,5049,5500,5301,5499,5022,5209,5026,5293,5309,5356,5329,5299,5303,5302,5332,5047,1026,5096,5070,5448,5420,1029,5037,5087,1008,5048,5043,5045,5230,5031,5088,5208,1003,5467,5294,5357,5044,1030,5076,5300,5027,5089,5311,5066,5069,5364,1009,5295,1013,5128,5203,1025,5032,5075,5476,1004,5072,5033,5359,5412,5409,5229,1005,5304,5449,5358,1006,5093}'::integer[]))
-> Hash (cost=72.22..72.22 rows=2122 width=8)
-> Seq Scan on tbl_products p (cost=0.00..72.22 rows=2122 width=8)