| GroupAggregate (cost=164.11..164.13 rows=1 width=133) |
| Group Key: sip.id |
| -> Sort (cost=164.11..164.11 rows=1 width=104) |
| Sort Key: sip.id |
| -> Hash Right Join (cost=37.29..164.10 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..90.80 rows=2880 width=61) |
| -> Hash (cost=37.27..37.27 rows=1 width=101) |
| -> Seq Scan on tbl_sales_invoice_products sip (cost=0.00..37.27 rows=1 width=101) |
| Filter: (sales_invoice_id = 2327) |