| Hash Left Join (cost=121.05..174.16 rows=39 width=69) |
| Hash Cond: (prod.product_serie = gs.id) |
| -> Hash Left Join (cost=59.14..112.15 rows=39 width=44) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Hash Left Join (cost=53.54..106.45 rows=39 width=32) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Left Join (cost=51.13..103.92 rows=39 width=24) |
| Hash Cond: (prod.product_brand = gb.id) |
| -> Bitmap Heap Scan on tbl_products prod (cost=43.22..95.91 rows=39 width=20) |
| Recheck Cond: (id = ANY ('{2269,1231,2255,1238,2269,2077,2171,2261,39,1245,2269,2075,941,2269,2261,1372,2083,2078,2086,1246,1372,2074,1584,2080,1372,1234,2085,1372,1562,672,2262,1025,2171,2076,2084,2072,2073,2242,1224}'::integer[])) |
| -> Bitmap Index Scan on tbl_products_pkey (cost=0.00..43.21 rows=39 width=0) |
| Index Cond: (id = ANY ('{2269,1231,2255,1238,2269,2077,2171,2261,39,1245,2269,2075,941,2269,2261,1372,2083,2078,2086,1246,1372,2074,1584,2080,1372,1234,2085,1372,1562,672,2262,1025,2171,2076,2084,2072,2073,2242,1224}'::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) |