| Hash Left Join (cost=129.98..191.20 rows=70 width=69) |
| Hash Cond: (prod.product_serie = gs.id) |
| -> Hash Left Join (cost=68.06..129.11 rows=70 width=44) |
| Hash Cond: (prod.product_component = gc.id) |
| -> Hash Left Join (cost=62.47..123.33 rows=70 width=32) |
| Hash Cond: (prod.product_type = gt.id) |
| -> Hash Left Join (cost=60.05..120.71 rows=70 width=24) |
| Hash Cond: (prod.product_brand = gb.id) |
| -> Bitmap Heap Scan on tbl_products prod (cost=52.14..112.62 rows=70 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,2233,2238,1372,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..52.12 rows=70 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,2233,2238,1372,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) |