| Limit (cost=82.82..82.88 rows=25 width=243) |
| -> Sort (cost=82.82..82.88 rows=25 width=243) |
| Sort Key: (CASE WHEN ((status = 0) OR (status = 0) OR ((NULL::integer) = 0)) THEN 1 ELSE 2 END), created_at DESC |
| -> Result (cost=0.00..82.24 rows=25 width=243) |
| -> Append (cost=0.00..81.80 rows=25 width=238) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=212) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=157) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=108) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=212) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=208) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=208) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=166) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=117) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=212) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=212) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=216) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=216) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=121) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=112) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=88) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=75) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=248) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=208) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=208) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=117) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=101) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=249) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=252) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=256) |
| One-Time Filter: false |
| -> Group (cost=81.30..81.31 rows=1 width=265) |
| Group Key: r.id, rvr.status, rsvr.status, rcvr.status |
| -> Sort (cost=81.30..81.30 rows=1 width=216) |
| Sort Key: r.id, rvr.status, rsvr.status, rcvr.status |
| -> Hash Left Join (cost=66.56..81.29 rows=1 width=216) |
| Hash Cond: (r.id = rcvr.erp_purchase_cost_id) |
| Filter: (((rvr.user_id = 1001) OR (rsvr.user_id = 1001) OR (rcvr.user_id = 1001)) AND ((rvr.status = 0) OR (rsvr.status = 0) OR (rcvr.status = 0))) |
| -> Hash Left Join (cost=44.38..58.27 rows=189 width=220) |
| Hash Cond: (r.id = rsvr.erp_purchase_cost_id) |
| -> Hash Left Join (cost=22.19..35.32 rows=189 width=212) |
| Hash Cond: (r.id = rvr.erp_purchase_cost_id) |
| -> Seq Scan on tbl_erp_purchase_costs r (cost=0.00..12.38 rows=189 width=204) |
| Filter: (status <> 0) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_cost_verify_rels rvr (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_cost_stop_verify_rels rsvr (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=22.12..22.12 rows=5 width=12) |
| -> Seq Scan on tbl_erp_purchase_cost_cancel_verify_rels rcvr (cost=0.00..22.12 rows=5 width=12) |
| Filter: (user_id = 1001) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=241) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=241) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=241) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=241) |
| One-Time Filter: false |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=265) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=241) |
| One-Time Filter: false |