| Hash Left Join (cost=124.22..181.10 rows=50 width=69) |
| Hash Cond: (prod.product_serie = gs.id) |
| -> Hash Left Join (cost=62.31..119.06 rows=50 width=44) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Hash Left Join (cost=56.71..113.33 rows=50 width=32) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Left Join (cost=54.29..110.77 rows=50 width=24) |
| Hash Cond: (prod.product_brand = gb.id) |
| -> Bitmap Heap Scan on tbl_products prod (cost=46.39..102.73 rows=50 width=20) |
| Recheck Cond: (id = ANY ('{1234,2080,1562,1372,1558,969,2171,2255,2078,868,2269,2261,989,1372,941,2177,2269,2265,2232,2261,867,2073,2075,2084,1238,2262,2083,870,1558,2085,1246,1245,1224,2261,2074,2231,1372,1231,672,2072,1025,2269,2242,2086,1372,2267,2076,2077,2171,39}'::integer[])) |
| -> Bitmap Index Scan on tbl_products_pkey (cost=0.00..46.38 rows=50 width=0) |
| Index Cond: (id = ANY ('{1234,2080,1562,1372,1558,969,2171,2255,2078,868,2269,2261,989,1372,941,2177,2269,2265,2232,2261,867,2073,2075,2084,1238,2262,2083,870,1558,2085,1246,1245,1224,2261,2074,2231,1372,1231,672,2072,1025,2269,2242,2086,1372,2267,2076,2077,2171,39}'::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) |