| HashAggregate (cost=19.50..19.72 rows=18 width=36) |
| Group Key: eip.product_id |
| -> Nested Loop (cost=0.00..19.41 rows=18 width=7) |
| Join Filter: (eip.erp_store_id = saleable_store.id) |
| -> Seq Scan on tbl_erp_stores saleable_store (cost=0.00..1.02 rows=1 width=4) |
| Filter: ((NOT is_delete) AND is_saleable_inventory) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..17.94 rows=36 width=11) |
| Filter: (product_id = ANY ('{2261,1372,2265,2263,2266}'::integer[])) |