QUERY PLAN
Aggregate (cost=157.36..157.37 rows=1 width=64)
-> HashAggregate (cost=100.78..129.06 rows=1886 width=68)
Group Key: p.id
-> Hash Left Join (cost=1.14..81.92 rows=1886 width=14)
Hash Cond: (p.id = eip.product_id)
-> Seq Scan on tbl_products p (cost=0.00..61.86 rows=1886 width=20)
-> Hash (cost=1.06..1.06 rows=6 width=14)
-> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..1.06 rows=6 width=14)