| Aggregate (cost=61.40..61.41 rows=1 width=8) |
| -> Sort (cost=60.94..61.02 rows=31 width=333) |
| Sort Key: (CASE WHEN ((sub.verify_status = 0) OR (sub.stop_verify_status = 0) OR (sub.cancel_verify_status = 0)) THEN 1 WHEN (sub.self_verify_at IS NOT NULL) THEN 2 ELSE 3 END), (CASE WHEN ((sub.verify_status = 0) OR (sub.stop_verify_status = 0) OR (sub.cancel_verify_status = 0)) THEN sub.created_at ELSE NULL::timestamp with time zone END) DESC NULLS LAST, sub.self_verify_at DESC NULLS LAST, sub.last_verify_at DESC NULLS LAST, sub.created_at DESC |
| -> Result (cost=0.00..60.17 rows=31 width=333) |
| -> Append (cost=0.00..59.40 rows=31 width=36) |
| -> Subquery Scan on sub (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=70) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 2" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=333) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=86) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 3" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 4" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 5" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=70) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 6" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 7" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 8" (cost=57.94..58.07 rows=2 width=36) |
| -> GroupAggregate (cost=57.94..58.05 rows=2 width=329) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Sort (cost=57.94..57.94 rows=2 width=62) |
| Sort Key: r.id, rvr.status, rsvr.status |
| -> Hash Left Join (cost=44.38..57.93 rows=2 width=62) |
| Hash Cond: (r.id = rsvr.erp_inventory_transfer_id) |
| Filter: ((CASE WHEN (1 = r.verify_type) THEN rvr.status ELSE CASE WHEN (r.next_verify_user = 1001) THEN 0 ELSE CASE WHEN (rvr.status = 0) THEN NULL::integer ELSE rvr.status END END END = 0) OR (CASE WHEN (1 = r.verify_type) THEN rsvr.status ELSE CASE WHEN (r.next_stop_verify_user = 1001) THEN 0 ELSE CASE WHEN (rsvr.status = 0) THEN NULL::integer ELSE rsvr.status END END END = 0)) |
| -> Hash Left Join (cost=22.19..34.99 rows=169 width=50) |
| Hash Cond: (r.id = rvr.erp_inventory_transfer_id) |
| -> Seq Scan on tbl_erp_inventory_transfers r (cost=0.00..12.12 rows=169 width=38) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=16) |
| -> Seq Scan on tbl_erp_inventory_transfer_verify_rels rvr (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=16) |
| -> Seq Scan on tbl_erp_inventory_transfer_stop_verify_rels rsvr (cost=0.00..22.12 rows=5 width=16) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 9" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=333) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=86) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 10" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 11" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 12" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=70) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 13" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 14" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 15" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 16" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 17" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 18" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 19" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 20" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 21" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 22" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 23" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 24" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=333) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=86) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 25" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 26" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 27" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 28" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 29" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 30" (cost=0.00..0.05 rows=1 width=36) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=329) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=62) |
| One-Time Filter: false |