QUERY PLAN
GroupAggregate (cost=236.12..236.78 rows=33 width=133)
Group Key: sip.id
-> Sort (cost=236.12..236.20 rows=33 width=104)
Sort Key: sip.id
-> Hash Right Join (cost=65.27..235.29 rows=33 width=104)
Hash Cond: ((lower((ip.title)::text) = lower((sip.title)::text)) AND (lower(ip.description) = lower(sip.description)))
-> Seq Scan on tbl_inventory_products ip (cost=0.00..90.80 rows=2880 width=61)
-> Hash (cost=64.77..64.77 rows=33 width=101)
-> Seq Scan on tbl_sales_invoice_products sip (cost=0.00..64.77 rows=33 width=101)
Filter: (sales_invoice_id = ANY ('{2327,2324,2322,2323,2321,2320,2319,2318,2317,2316,2315,2314,2313,2312,2311,2308,2307,2306,2305,2302}'::integer[]))