| Sort (cost=146.31..146.38 rows=27 width=465) |
| Sort Key: eip.created_at DESC |
| -> HashAggregate (cost=145.40..145.67 rows=27 width=465) |
| Group Key: eip.id |
| -> Hash Right Join (cost=81.06..139.62 rows=2312 width=465) |
| Hash Cond: (eiops.erp_inventory_overflow_id = eios.id) |
| -> Seq Scan on tbl_erp_inventory_overflow_projects eiops (cost=0.00..28.50 rows=1850 width=4) |
| -> Hash (cost=77.94..77.94 rows=250 width=469) |
| -> Hash Left Join (cost=39.33..77.94 rows=250 width=469) |
| Hash Cond: (eip.erp_inventory_overflow_id = eios.id) |
| -> Hash Right Join (cost=25.28..63.22 rows=250 width=465) |
| Hash Cond: (epips.erp_purchase_inbound_id = epis.id) |
| -> Seq Scan on tbl_erp_purchase_inbound_projects epips (cost=0.00..28.50 rows=1850 width=4) |
| -> Hash (cost=24.95..24.95 rows=27 width=469) |
| -> Hash Right Join (cost=12.34..24.95 rows=27 width=469) |
| Hash Cond: (epis.id = eip.erp_purchase_inbound_id) |
| -> Seq Scan on tbl_erp_purchase_inbounds epis (cost=0.00..11.70 rows=170 width=4) |
| -> Hash (cost=12.00..12.00 rows=27 width=465) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..12.00 rows=27 width=465) |
| Filter: ((NOT is_build) AND (inventory > '0'::numeric)) |
| -> Hash (cost=11.80..11.80 rows=180 width=4) |
| -> Seq Scan on tbl_erp_inventory_overflows eios (cost=0.00..11.80 rows=180 width=4) |