| Nested Loop Left Join (cost=24.28..59.83 rows=1 width=645) |
| Filter: ((eip.erp_inventory_disassemble_id IS NULL) OR (eid.status <> 6)) |
| -> Nested Loop Left Join (cost=24.13..51.66 rows=1 width=649) |
| Join Filter: (eip.erp_inventory_build_id = eib.id) |
| Filter: ((eip.erp_inventory_build_id IS NULL) OR (eib.status <> 6)) |
| -> Nested Loop Left Join (cost=24.13..50.61 rows=1 width=653) |
| Join Filter: (eip.erp_inventory_overflow_id = eio.id) |
| Filter: ((eip.erp_inventory_overflow_id IS NULL) OR (eio.status <> 6)) |
| -> Nested Loop Left Join (cost=24.13..49.41 rows=1 width=657) |
| Join Filter: (eip.erp_purchase_gift_id = epg.id) |
| Filter: ((eip.erp_purchase_gift_id IS NULL) OR (epg.status <> 6)) |
| -> Nested Loop Left Join (cost=24.13..47.91 rows=1 width=661) |
| Filter: ((eip.erp_purchase_inbound_id IS NULL) OR (epi.status <> 6)) |
| -> Nested Loop (cost=23.99..39.73 rows=1 width=665) |
| Join Filter: (eipsn.erp_inventory_product_id = eip.id) |
| -> Seq Scan on tbl_erp_inventory_product_sns eipsn (cost=23.99..25.51 rows=1 width=645) |
| Filter: ((NOT (hashed SubPlan 1)) AND ((sn)::text = 'exert'::text)) |
| SubPlan 1 |
| -> Nested Loop (cost=0.14..23.98 rows=1 width=516) |
| -> Nested Loop (cost=0.00..15.81 rows=1 width=520) |
| Join Filter: (pps.erp_purchase_inbound_product_id = pp.id) |
| -> Seq Scan on tbl_erp_purchase_inbound_product_sns pps (cost=0.00..1.35 rows=35 width=520) |
| -> Materialize (cost=0.00..12.37 rows=4 width=8) |
| -> Seq Scan on tbl_erp_purchase_inbound_products pp (cost=0.00..12.35 rows=4 width=8) |
| Filter: (erp_purchase_inbound_id = 196) |
| -> Index Only Scan using tbl_erp_purchase_inbounds_pkey on tbl_erp_purchase_inbounds p (cost=0.14..8.16 rows=1 width=4) |
| Index Cond: (id = 196) |
| -> Seq Scan on tbl_erp_inventory_products eip (cost=0.00..14.21 rows=1 width=24) |
| Filter: (product_id = 2265) |
| -> Index Scan using tbl_erp_purchase_inbounds_pkey on tbl_erp_purchase_inbounds epi (cost=0.14..8.16 rows=1 width=6) |
| Index Cond: (eip.erp_purchase_inbound_id = id) |
| -> Seq Scan on tbl_erp_purchase_gifts epg (cost=0.00..1.20 rows=20 width=6) |
| -> Seq Scan on tbl_erp_inventory_overflows eio (cost=0.00..1.08 rows=8 width=6) |
| -> Seq Scan on tbl_erp_inventory_builds eib (cost=0.00..1.02 rows=2 width=6) |
| -> Index Scan using tbl_erp_inventory_disassembles_pkey on tbl_erp_inventory_disassembles eid (cost=0.14..8.16 rows=1 width=6) |
| Index Cond: (eip.erp_inventory_disassemble_id = id) |