| Subquery Scan on sub (cost=50.25..50.30 rows=1 width=202) |
| -> Group (cost=50.25..50.29 rows=1 width=210) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Sort (cost=50.25..50.26 rows=1 width=123) |
| Sort Key: rvr.status, rsvr.status |
| -> Nested Loop Left Join (cost=0.00..50.24 rows=1 width=123) |
| Join Filter: (rsvr.erp_inventory_overflow_id = r.id) |
| -> Nested Loop Left Join (cost=0.00..25.68 rows=1 width=119) |
| Join Filter: (rvr.erp_inventory_overflow_id = r.id) |
| -> Seq Scan on tbl_erp_inventory_overflows r (cost=0.00..1.12 rows=1 width=115) |
| Filter: ((status <> 0) AND (id = 4)) |
| -> Seq Scan on tbl_erp_inventory_overflow_verify_rels rvr (cost=0.00..24.55 rows=1 width=8) |
| Filter: ((erp_inventory_overflow_id = 4) AND (user_id = 1000)) |
| -> Seq Scan on tbl_erp_inventory_overflow_stop_verify_rels rsvr (cost=0.00..24.55 rows=1 width=8) |
| Filter: ((erp_inventory_overflow_id = 4) AND (user_id = 1000)) |