QUERY PLAN
Limit (cost=113.99..114.09 rows=37 width=228)
-> Sort (cost=113.99..114.09 rows=37 width=228)
Sort Key: (CASE WHEN ((sub.verify_status = 0) OR (sub.stop_verify_status = 0) OR (sub.cancel_verify_status = 0)) THEN 1 ELSE 2 END), sub.created_at DESC
-> Result (cost=0.00..113.03 rows=37 width=228)
-> Append (cost=0.00..112.38 rows=37 width=224)
-> Subquery Scan on sub (cost=0.00..0.04 rows=1 width=154)
-> HashAggregate (cost=0.00..0.03 rows=1 width=162)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=79)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 2" (cost=110.68..111.26 rows=11 width=189)
-> Group (cost=110.68..111.15 rows=11 width=201)
Group Key: r.id, rvr.status, rsvr.status, rcvr.status
-> Sort (cost=110.68..110.71 rows=11 width=122)
Sort Key: r.id, rvr.status, rsvr.status, rcvr.status
-> Hash Left Join (cost=24.86..110.49 rows=11 width=122)
Hash Cond: (r.id = rsvr.erp_purchase_order_id)
Filter: (((rvr.user_id = 1001) OR (rsvr.user_id = 1001) OR (rcvr.user_id = 1001)) AND ((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) OR (CASE WHEN (1 = r.verify_type) THEN rcvr.status ELSE CASE WHEN (r.next_cancel_verify_user = 1001) THEN 0 ELSE CASE WHEN (rcvr.status = 0) THEN NULL::integer ELSE rcvr.status END END END = 0)))
-> Hash Left Join (cost=23.81..101.73 rows=2043 width=126)
Hash Cond: (r.id = rcvr.erp_purchase_order_id)
-> Hash Left Join (cost=1.62..71.83 rows=2043 width=118)
Hash Cond: (r.id = rvr.erp_purchase_order_id)
-> Seq Scan on tbl_erp_purchase_orders r (cost=0.00..62.54 rows=2043 width=110)
Filter: (status <> 0)
-> Hash (cost=1.61..1.61 rows=1 width=12)
-> Seq Scan on tbl_erp_purchase_order_verify_rels rvr (cost=0.00..1.61 rows=1 width=12)
Filter: (user_id = 1001)
-> Hash (cost=22.12..22.12 rows=5 width=12)
-> Seq Scan on tbl_erp_purchase_order_cancel_verify_rels rcvr (cost=0.00..22.12 rows=5 width=12)
Filter: (user_id = 1001)
-> Hash (cost=1.04..1.04 rows=1 width=12)
-> Seq Scan on tbl_erp_purchase_order_stop_verify_rels rsvr (cost=0.00..1.04 rows=1 width=12)
Filter: (user_id = 1001)
-> Subquery Scan on "*SELECT* 3" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=222)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 4" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=218)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 5" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=218)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 6" (cost=0.00..0.05 rows=1 width=197)
-> HashAggregate (cost=0.00..0.04 rows=1 width=209)
Group Key: id, status, status, status
-> Result (cost=0.00..0.00 rows=0 width=130)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 7" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=222)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 8" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=222)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 9" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=226)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 10" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=226)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 11" (cost=0.00..0.04 rows=1 width=141)
-> HashAggregate (cost=0.00..0.03 rows=1 width=149)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=110)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 12" (cost=0.00..0.04 rows=1 width=140)
-> HashAggregate (cost=0.00..0.03 rows=1 width=148)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=110)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 13" (cost=0.00..0.04 rows=1 width=143)
-> HashAggregate (cost=0.00..0.03 rows=1 width=151)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=104)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 14" (cost=0.00..0.04 rows=1 width=133)
-> HashAggregate (cost=0.00..0.03 rows=1 width=141)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=94)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 15" (cost=0.00..0.04 rows=1 width=210)
-> HashAggregate (cost=0.00..0.03 rows=1 width=218)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=131)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 16" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=218)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 17" (cost=0.00..0.04 rows=1 width=149)
-> HashAggregate (cost=0.00..0.03 rows=1 width=157)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=111)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 18" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=259)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 19" (cost=0.00..0.04 rows=1 width=124)
-> HashAggregate (cost=0.00..0.03 rows=1 width=132)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=93)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 20" (cost=0.00..0.04 rows=1 width=133)
-> HashAggregate (cost=0.00..0.03 rows=1 width=141)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=102)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 21" (cost=0.00..0.05 rows=1 width=297)
-> HashAggregate (cost=0.00..0.04 rows=1 width=309)
Group Key: id, status, status, status
-> Result (cost=0.00..0.00 rows=0 width=230)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 22" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=251)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 23" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=251)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 24" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=251)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 25" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=251)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 26" (cost=0.00..0.04 rows=1 width=297)
-> HashAggregate (cost=0.00..0.03 rows=1 width=305)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=251)
One-Time Filter: false
-> Subquery Scan on "*SELECT* 27" (cost=0.00..0.05 rows=1 width=215)
-> HashAggregate (cost=0.00..0.04 rows=1 width=223)
Group Key: id, status, status
-> Result (cost=0.00..0.00 rows=0 width=113)
One-Time Filter: false