QUERY PLAN
GroupAggregate (cost=23.66..23.77 rows=5 width=40)
Group Key: product_id, erp_store_id
-> Sort (cost=23.66..23.67 rows=5 width=11)
Sort Key: product_id
-> Seq Scan on tbl_erp_inventory_products (cost=0.00..23.60 rows=5 width=11)
Filter: ((inventory > '0'::numeric) AND (erp_store_id = 1) AND (product_id = ANY ('{2266,2263,2265,2261,2171,2268,1528,1562,2177,2262}'::integer[])))