| Hash Left Join (cost=121.92..175.97 rows=42 width=69) |
| Hash Cond: (prod.product_serie = gs.id) |
| -> Hash Left Join (cost=60.01..113.95 rows=42 width=44) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Hash Left Join (cost=54.41..108.24 rows=42 width=32) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Left Join (cost=51.99..105.70 rows=42 width=24) |
| Hash Cond: (prod.product_brand = gb.id) |
| -> Bitmap Heap Scan on tbl_products prod (cost=44.09..97.68 rows=42 width=20) |
| Recheck Cond: (id = ANY ('{2231,1245,868,867,2085,2269,2084,2080,2073,2076,2086,2265,2074,1234,39,1224,2075,1025,870,941,2261,1558,2262,2078,2077,2255,2232,2171,2091,1372,1562,1238,989,672,2083,2072,2267,1246,969,1231,2177,2242}'::integer[])) |
| -> Bitmap Index Scan on tbl_products_pkey (cost=0.00..44.07 rows=42 width=0) |
| Index Cond: (id = ANY ('{2231,1245,868,867,2085,2269,2084,2080,2073,2076,2086,2265,2074,1234,39,1224,2075,1025,870,941,2261,1558,2262,2078,2077,2255,2232,2171,2091,1372,1562,1238,989,672,2083,2072,2267,1246,969,1231,2177,2242}'::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) |