| Sort (cost=71.65..71.65 rows=1 width=126) |
| Sort Key: eip.wrote_date, eip.created_at |
| -> Group (cost=71.63..71.64 rows=1 width=126) |
| Group Key: eip.id |
| -> Sort (cost=71.63..71.64 rows=1 width=126) |
| Sort Key: eip.id |
| -> Nested Loop Left Join (cost=36.15..71.62 rows=1 width=126) |
| Join Filter: (epgs.id = eip.erp_purchase_gift_id) |
| Filter: ((epips.client_id = 3462) OR (epgs.client_id = 3462) OR (eiops.client_id = 3462)) |
| -> Hash Right Join (cost=36.15..69.96 rows=1 width=134) |
| Hash Cond: (eios.id = eip.erp_inventory_overflow_id) |
| Filter: ((epips.project_id = 4174) OR (eiops.project_id = 4174)) |
| -> Hash Right Join (cost=1.23..34.68 rows=92 width=12) |
| 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=12) |
| -> 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) |
| -> Hash (cost=34.91..34.91 rows=1 width=134) |
| -> Nested Loop Left Join (cost=8.17..34.91 rows=1 width=134) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..22.27 rows=1 width=126) |
| Filter: ((product_id = 870) AND (erp_store_id = 1) AND ((inventory > '0'::numeric) OR (id = ANY ('{517,529,513,516,529,517}'::integer[])))) |
| -> Hash Right Join (cost=8.17..12.62 rows=1 width=12) |
| 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=12) |
| -> Hash (cost=8.16..8.16 rows=1 width=4) |
| -> Index Only Scan using tbl_erp_purchase_inbounds_pkey on tbl_erp_purchase_inbounds epis (cost=0.14..8.16 rows=1 width=4) |
| Index Cond: (id = eip.erp_purchase_inbound_id) |
| -> Seq Scan on tbl_erp_purchase_gifts epgs (cost=0.00..1.22 rows=22 width=8) |