| Append (cost=0.00..52.44 rows=27 width=237) |
| -> 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=0.00..0.05 rows=1 width=189) |
| -> HashAggregate (cost=0.00..0.04 rows=1 width=201) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=122) |
| One-Time Filter: false |
| -> 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=51.26..51.31 rows=1 width=297) |
| -> Group (cost=51.26..51.30 rows=1 width=309) |
| Group Key: r.id, rvr.status, rsvr.status, rcvr.status |
| -> Sort (cost=51.26..51.26 rows=1 width=230) |
| Sort Key: rvr.status, rsvr.status, rcvr.status |
| -> Nested Loop Left Join (cost=0.00..51.25 rows=1 width=230) |
| Join Filter: (rcvr.erp_purchase_cost_id = r.id) |
| Filter: ((rvr.user_id = 1001) OR (rsvr.user_id = 1001) OR (rcvr.user_id = 1001)) |
| -> Nested Loop Left Join (cost=0.00..26.68 rows=1 width=234) |
| Join Filter: (rsvr.erp_purchase_cost_id = r.id) |
| -> Nested Loop Left Join (cost=0.00..2.12 rows=1 width=226) |
| Join Filter: (rvr.erp_purchase_cost_id = r.id) |
| -> Seq Scan on tbl_erp_purchase_costs r (cost=0.00..1.07 rows=1 width=218) |
| Filter: ((status <> 0) AND (id = 7)) |
| -> Seq Scan on tbl_erp_purchase_cost_verify_rels rvr (cost=0.00..1.03 rows=1 width=12) |
| Filter: ((erp_purchase_cost_id = 7) AND (user_id = 1001)) |
| -> Seq Scan on tbl_erp_purchase_cost_stop_verify_rels rsvr (cost=0.00..24.55 rows=1 width=12) |
| Filter: ((erp_purchase_cost_id = 7) AND (user_id = 1001)) |
| -> Seq Scan on tbl_erp_purchase_cost_cancel_verify_rels rcvr (cost=0.00..24.55 rows=1 width=12) |
| Filter: ((erp_purchase_cost_id = 7) AND (user_id = 1001)) |
| -> 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 |