| Aggregate (cost=10.87..10.88 rows=1 width=8) |
| -> Sort (cost=10.21..10.32 rows=44 width=417) |
| Sort Key: eip.created_at DESC |
| -> HashAggregate (cost=8.57..9.01 rows=44 width=417) |
| Group Key: eip.id |
| -> Hash Left Join (cost=3.72..8.46 rows=44 width=12) |
| Hash Cond: (eip.erp_purchase_inbound_id = epis.id) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..4.34 rows=44 width=32) |
| Filter: ((NOT is_build) AND (inventory > '0'::numeric)) |
| -> Hash (cost=3.26..3.26 rows=37 width=4) |
| -> Hash Right Join (cost=1.83..3.26 rows=37 width=4) |
| Hash Cond: (epips.erp_purchase_inbound_id = epis.id) |
| -> Seq Scan on tbl_erp_purchase_inbound_projects epips (cost=0.00..1.33 rows=33 width=4) |
| -> Hash (cost=1.37..1.37 rows=37 width=4) |
| -> Seq Scan on tbl_erp_purchase_inbounds epis (cost=0.00..1.37 rows=37 width=4) |