| GroupAggregate (cost=17.47..17.89 rows=4 width=548) |
| Group Key: eip.product_id |
| -> Sort (cost=17.47..17.48 rows=4 width=88) |
| Sort Key: eip.product_id |
| -> Nested Loop (cost=0.00..17.43 rows=4 width=88) |
| 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.30 rows=9 width=92) |
| Filter: (product_id = ANY ('{2232,870,868}'::integer[])) |