QUERY PLAN
HashAggregate (cost=17.48..18.06 rows=11 width=548)
Group Key: eip.product_id
-> Nested Loop (cost=0.00..16.93 rows=11 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=22 width=92)
Filter: (product_id = ANY ('{2261,2177}'::integer[]))