| Aggregate (cost=1046.64..1046.65 rows=1 width=8) |
| -> Append (cost=0.00..1033.66 rows=5195 width=0) |
| -> Subquery Scan on sub (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 2" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=309) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=16) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 3" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 4" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 5" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 6" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=309) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=16) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 7" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 8" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 9" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 10" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 11" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 12" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 13" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 14" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 15" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 16" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 17" (cost=929.76..1033.14 rows=5169 width=0) |
| -> HashAggregate (cost=929.76..981.45 rows=5169 width=305) |
| Group Key: r.id, rvr.status, rsvr.status |
| -> Hash Left Join (cost=495.07..890.99 rows=5169 width=12) |
| Hash Cond: (r.id = rsvr.erp_cash_cost_ticket_id) |
| Filter: ((rvr.user_id = 1001) OR (rsvr.user_id = 1001)) |
| -> Hash Right Join (cost=494.04..861.93 rows=7469 width=12) |
| Hash Cond: (rvr.erp_cash_cost_ticket_id = r.id) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_verify_rels rvr (cost=0.00..348.33 rows=7449 width=12) |
| Filter: (user_id = 1001) |
| -> Hash (cost=400.68..400.68 rows=7469 width=4) |
| -> Seq Scan on tbl_erp_cash_cost_tickets r (cost=0.00..400.68 rows=7469 width=4) |
| Filter: (status <> 0) |
| -> Hash (cost=1.02..1.02 rows=1 width=12) |
| -> Seq Scan on tbl_erp_cash_cost_ticket_stop_verify_rels rsvr (cost=0.00..1.02 rows=1 width=12) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on "*SELECT* 18" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 19" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 20" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 21" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=309) |
| Group Key: id, status, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=16) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 22" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 23" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 24" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 25" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 26" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |
| -> Subquery Scan on "*SELECT* 27" (cost=0.00..0.02 rows=1 width=0) |
| -> HashAggregate (cost=0.00..0.01 rows=1 width=305) |
| Group Key: id, status, status |
| -> Result (cost=0.00..0.00 rows=0 width=12) |
| One-Time Filter: false |