| Hash Left Join (cost=129.69..189.68 rows=69 width=69) |
| Hash Cond: (prod.product_serie = gs.id) |
| -> Hash Left Join (cost=67.78..127.59 rows=69 width=44) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Hash Left Join (cost=62.18..121.81 rows=69 width=32) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Left Join (cost=59.76..119.20 rows=69 width=24) |
| Hash Cond: (prod.product_brand = gb.id) |
| -> Bitmap Heap Scan on tbl_products prod (cost=51.85..111.11 rows=69 width=20) |
| Recheck Cond: (id = ANY ('{2231,984,1528,868,2253,1774,867,2269,2227,1671,2244,1890,2241,1876,1148,1973,855,1007,2228,870,1880,942,941,2261,1882,1558,2237,1096,851,2258,2243,1942,2232,2041,2230,2171,1511,1340,1928,41,2238,2233,587,1562,2224,2259,2235,2225,989,2236,1925,922,2240,994,154,1929,1927,2239,2257,969,1737,1780,2177,1923,1275,960,2260,2226,1339}'::integer[])) |
| -> Bitmap Index Scan on tbl_products_pkey (cost=0.00..51.84 rows=69 width=0) |
| Index Cond: (id = ANY ('{2231,984,1528,868,2253,1774,867,2269,2227,1671,2244,1890,2241,1876,1148,1973,855,1007,2228,870,1880,942,941,2261,1882,1558,2237,1096,851,2258,2243,1942,2232,2041,2230,2171,1511,1340,1928,41,2238,2233,587,1562,2224,2259,2235,2225,989,2236,1925,922,2240,994,154,1929,1927,2239,2257,969,1737,1780,2177,1923,1275,960,2260,2226,1339}'::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) |