| Limit (cost=86.00..86.05 rows=20 width=143) |
| -> Sort (cost=86.00..86.11 rows=44 width=143) |
| Sort Key: p.updated_at DESC NULLS LAST |
| -> HashAggregate (cost=84.39..84.83 rows=44 width=143) |
| Group Key: p.id |
| -> Hash Join (cost=4.89..84.28 rows=44 width=143) |
| Hash Cond: (p.id = eip.product_id) |
| -> Seq Scan on tbl_products p (cost=0.00..64.40 rows=1940 width=143) |
| -> Hash (cost=4.34..4.34 rows=44 width=4) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..4.34 rows=44 width=4) |
| Filter: (inventory > '0'::numeric) |