QUERY PLAN
Limit (cost=155.68..155.73 rows=20 width=142)
-> Sort (cost=155.68..160.39 rows=1886 width=142)
Sort Key: p.updated_at DESC, p.id DESC
-> HashAggregate (cost=86.63..105.49 rows=1886 width=142)
Group Key: p.id
-> Hash Left Join (cost=1.14..81.92 rows=1886 width=142)
Hash Cond: (p.id = eip.product_id)
-> Seq Scan on tbl_products p (cost=0.00..61.86 rows=1886 width=142)
-> Hash (cost=1.06..1.06 rows=6 width=4)
-> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..1.06 rows=6 width=4)