| Sort (cost=75.17..75.33 rows=64 width=166) |
| Sort Key: eip.created_at DESC |
| -> HashAggregate (cost=72.61..73.25 rows=64 width=166) |
| Group Key: eip.id |
| -> Hash Left Join (cost=64.88..71.13 rows=592 width=166) |
| Hash Cond: (eip.erp_inventory_overflow_id = eios.id) |
| -> Hash Right Join (cost=29.05..34.29 rows=64 width=166) |
| Hash Cond: (epips.erp_purchase_inbound_id = epis.id) |
| -> Seq Scan on tbl_erp_purchase_inbound_projects epips (cost=0.00..3.93 rows=193 width=4) |
| -> Hash (cost=28.25..28.25 rows=64 width=170) |
| -> Hash Left Join (cost=9.79..28.25 rows=64 width=170) |
| Hash Cond: (eip.erp_purchase_inbound_id = epis.id) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..18.29 rows=64 width=166) |
| Filter: ((NOT is_build) AND (erp_store_id = 1) AND ((inventory > '0'::numeric) OR (id = 533))) |
| -> Hash (cost=7.13..7.13 rows=213 width=4) |
| -> Seq Scan on tbl_erp_purchase_inbounds epis (cost=0.00..7.13 rows=213 width=4) |
| -> Hash (cost=34.68..34.68 rows=92 width=4) |
| -> Hash Right Join (cost=1.23..34.68 rows=92 width=4) |
| 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=1.10..1.10 rows=10 width=4) |
| -> Seq Scan on tbl_erp_inventory_overflows eios (cost=0.00..1.10 rows=10 width=4) |