| Hash Left Join (cost=125.37..183.40 rows=54 width=69) |
| Hash Cond: (prod.product_serie = gs.id) |
| -> Hash Left Join (cost=63.46..121.34 rows=54 width=44) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Hash Left Join (cost=57.86..115.60 rows=54 width=32) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Left Join (cost=55.44..113.03 rows=54 width=24) |
| Hash Cond: (prod.product_brand = gb.id) |
| -> Bitmap Heap Scan on tbl_products prod (cost=47.54..104.99 rows=54 width=20) |
| Recheck Cond: (id = ANY ('{1238,1234,2231,2078,2177,2076,868,1558,2267,2255,2261,39,867,1245,2177,1372,2074,2261,2083,672,2269,2232,2269,1025,989,2261,2171,870,2265,2073,1224,941,2075,1372,2267,2072,1231,1372,2171,2077,1562,2084,2261,969,2080,2085,1558,2262,2242,2269,1372,2091,1246,2086}'::integer[])) |
| -> Bitmap Index Scan on tbl_products_pkey (cost=0.00..47.52 rows=54 width=0) |
| Index Cond: (id = ANY ('{1238,1234,2231,2078,2177,2076,868,1558,2267,2255,2261,39,867,1245,2177,1372,2074,2261,2083,672,2269,2232,2269,1025,989,2261,2171,870,2265,2073,1224,941,2075,1372,2267,2072,1231,1372,2171,2077,1562,2084,2261,969,2080,2085,1558,2262,2242,2269,1372,2091,1246,2086}'::integer[])) |
| -> Hash (cost=5.18..5.18 rows=218 width=12) |
| -> Seq Scan on tbl_product_brands gb (cost=0.00..5.18 rows=218 width=12) |
| -> Hash (cost=1.63..1.63 rows=63 width=16) |
| -> Seq Scan on tbl_product_types gt (cost=0.00..1.63 rows=63 width=16) |
| -> Hash (cost=3.60..3.60 rows=160 width=20) |
| -> Seq Scan on tbl_product_components gc (cost=0.00..3.60 rows=160 width=20) |
| -> Hash (cost=41.96..41.96 rows=1596 width=33) |
| -> Seq Scan on tbl_product_series gs (cost=0.00..41.96 rows=1596 width=33) |