| Subquery Scan on sub (cost=57.30..57.37 rows=1 width=321) |
| -> GroupAggregate (cost=57.30..57.36 rows=1 width=329) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Sort (cost=57.30..57.30 rows=1 width=250) |
| Sort Key: rvr.status, rsvr.status |
| -> Nested Loop Left Join (cost=0.14..57.29 rows=1 width=250) |
| Join Filter: (rsvr.erp_inventory_transfer_id = r.id) |
| -> Nested Loop Left Join (cost=0.14..32.73 rows=1 width=238) |
| Join Filter: (rvr.erp_inventory_transfer_id = r.id) |
| -> Index Scan using tbl_erp_inventory_transfers_pkey on tbl_erp_inventory_transfers r (cost=0.14..8.16 rows=1 width=226) |
| Index Cond: (id = 2) |
| Filter: (status <> 0) |
| -> Seq Scan on tbl_erp_inventory_transfer_verify_rels rvr (cost=0.00..24.55 rows=1 width=16) |
| Filter: ((erp_inventory_transfer_id = 2) AND (user_id = 1000)) |
| -> Seq Scan on tbl_erp_inventory_transfer_stop_verify_rels rsvr (cost=0.00..24.55 rows=1 width=16) |
| Filter: ((erp_inventory_transfer_id = 2) AND (user_id = 1000)) |