| GroupAggregate (cost=164.15..164.21 rows=3 width=133) |
| Group Key: sip.id |
| -> Sort (cost=164.15..164.16 rows=3 width=104) |
| Sort Key: sip.id |
| -> Hash Right Join (cost=37.32..164.13 rows=3 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=37.27..37.27 rows=3 width=101) |
| -> Seq Scan on tbl_sales_invoice_products sip (cost=0.00..37.27 rows=3 width=101) |
| Filter: (sales_invoice_id = ANY ('{2326,2325}'::integer[])) |