| GroupAggregate (cost=103.10..103.12 rows=1 width=133) |
| Group Key: sip.id |
| -> Sort (cost=103.10..103.10 rows=1 width=104) |
| Sort Key: sip.id |
| -> Hash Right Join (cost=23.80..103.09 rows=1 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..56.90 rows=1790 width=61) |
| -> Hash (cost=23.79..23.79 rows=1 width=101) |
| -> Seq Scan on tbl_sales_invoice_products sip (cost=0.00..23.79 rows=1 width=101) |
| Filter: (sales_invoice_id = 1975) |