| GroupAggregate (cost=17.73..18.18 rows=4 width=580) |
| Group Key: eip.product_id |
| -> Sort (cost=17.73..17.75 rows=4 width=64) |
| Sort Key: eip.product_id |
| -> Nested Loop (cost=0.00..17.70 rows=4 width=64) |
| 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..16.56 rows=9 width=68) |
| Filter: (product_id = ANY ('{2232,870,868}'::integer[])) |