| GroupAggregate (cost=16.99..17.83 rows=8 width=548) |
| Group Key: eip.product_id |
| -> Sort (cost=16.99..17.01 rows=8 width=88) |
| Sort Key: eip.product_id |
| -> Nested Loop (cost=0.00..16.87 rows=8 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..15.64 rows=17 width=92) |
| Filter: (product_id = ANY ('{1372,2261}'::integer[])) |