| Limit (cost=108.37..108.42 rows=20 width=40) |
| -> Sort (cost=108.37..108.89 rows=205 width=40) |
| Sort Key: (COALESCE(sub.approvesort, 0)) DESC, (COALESCE(sub.cancelapprovesort, 0)) DESC, sub.created_at DESC |
| -> Append (cost=19.46..102.92 rows=205 width=40) |
| -> Subquery Scan on sub (cost=19.46..19.49 rows=1 width=40) |
| -> Group (cost=19.46..19.48 rows=1 width=36) |
| Group Key: r.id, (CASE WHEN ((rvr.status = 0) AND (r.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr.status = 0) AND (r.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Sort (cost=19.46..19.46 rows=1 width=36) |
| Sort Key: r.id, (CASE WHEN ((rvr.status = 0) AND (r.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr.status = 0) AND (r.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Nested Loop Left Join (cost=10.49..19.45 rows=1 width=36) |
| Join Filter: (crvr.punch_repair_id = r.id) |
| -> Hash Join (cost=10.49..18.35 rows=1 width=40) |
| Hash Cond: (rvr.punch_repair_id = r.id) |
| -> Seq Scan on tbl_punch_repair_verify_rels rvr (cost=0.00..7.49 rows=142 width=8) |
| Filter: (user_id = 1001) |
| -> Hash (cost=10.48..10.48 rows=1 width=36) |
| -> Seq Scan on tbl_punch_repairs r (cost=0.00..10.48 rows=1 width=36) |
| Filter: (status = ANY ('{1,5}'::integer[])) |
| -> Seq Scan on tbl_punch_repair_cancel_verify_rels crvr (cost=0.00..1.04 rows=4 width=8) |
| -> Subquery Scan on sub_1 (cost=15.27..15.30 rows=1 width=40) |
| -> Group (cost=15.27..15.29 rows=1 width=36) |
| Group Key: r_1.id, (CASE WHEN ((rvr_1.status = 0) AND (r_1.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr_1.status = 0) AND (r_1.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Sort (cost=15.27..15.27 rows=1 width=36) |
| Sort Key: r_1.id, (CASE WHEN ((rvr_1.status = 0) AND (r_1.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr_1.status = 0) AND (r_1.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Nested Loop Left Join (cost=8.89..15.26 rows=1 width=36) |
| Join Filter: (crvr_1.punch_away_id = r_1.id) |
| -> Hash Join (cost=8.89..14.16 rows=1 width=40) |
| Hash Cond: (rvr_1.punch_away_id = r_1.id) |
| -> Seq Scan on tbl_punch_away_verify_rels rvr_1 (cost=0.00..4.86 rows=151 width=8) |
| Filter: (user_id = 1001) |
| -> Hash (cost=8.86..8.86 rows=2 width=36) |
| -> Seq Scan on tbl_punch_aways r_1 (cost=0.00..8.86 rows=2 width=36) |
| Filter: (status = ANY ('{1,5}'::integer[])) |
| -> Seq Scan on tbl_punch_away_cancel_verify_rels crvr_1 (cost=0.00..1.04 rows=4 width=8) |
| -> Subquery Scan on sub_2 (cost=42.41..48.41 rows=200 width=40) |
| -> HashAggregate (cost=42.41..46.41 rows=200 width=36) |
| Group Key: r_2.id, CASE WHEN ((rvr_2.status = 0) AND (r_2.next_verify_user = 1001)) THEN 1 ELSE 0 END, CASE WHEN ((crvr_2.status = 0) AND (r_2.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END |
| -> Hash Right Join (cost=2.05..35.14 rows=970 width=36) |
| Hash Cond: (crvr_2.punch_overtime_id = r_2.id) |
| -> Seq Scan on tbl_punch_overtime_cancel_verify_rels crvr_2 (cost=0.00..19.70 rows=970 width=8) |
| -> Hash (cost=2.04..2.04 rows=1 width=40) |
| -> Nested Loop (cost=0.00..2.04 rows=1 width=40) |
| Join Filter: (r_2.id = rvr_2.punch_overtime_id) |
| -> Seq Scan on tbl_punch_overtimes r_2 (cost=0.00..1.01 rows=1 width=36) |
| Filter: (status = ANY ('{1,5}'::integer[])) |
| -> Seq Scan on tbl_punch_overtime_verify_rels rvr_2 (cost=0.00..1.01 rows=1 width=8) |
| Filter: (user_id = 1001) |
| -> Subquery Scan on sub_3 (cost=15.78..15.84 rows=2 width=40) |
| -> Group (cost=15.78..15.82 rows=2 width=36) |
| Group Key: r_3.id, (CASE WHEN ((rvr_3.status = 0) AND (r_3.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr_3.status = 0) AND (r_3.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Sort (cost=15.78..15.79 rows=2 width=36) |
| Sort Key: r_3.id, (CASE WHEN ((rvr_3.status = 0) AND (r_3.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr_3.status = 0) AND (r_3.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Hash Join (cost=11.33..15.77 rows=2 width=36) |
| Hash Cond: (rvr_3.punch_leave_id = r_3.id) |
| -> Seq Scan on tbl_punch_leave_verify_rels rvr_3 (cost=0.00..4.08 rows=88 width=8) |
| Filter: (user_id = 1001) |
| -> Hash (cost=11.29..11.29 rows=3 width=40) |
| -> Hash Right Join (cost=10.07..11.29 rows=3 width=40) |
| Hash Cond: (crvr_3.punch_leave_id = r_3.id) |
| -> Seq Scan on tbl_punch_leave_cancel_verify_rels crvr_3 (cost=0.00..1.17 rows=17 width=8) |
| -> Hash (cost=10.04..10.04 rows=3 width=36) |
| -> Seq Scan on tbl_punch_leaves r_3 (cost=0.00..10.04 rows=3 width=36) |
| Filter: (status = ANY ('{1,5}'::integer[])) |
| -> Subquery Scan on sub_4 (cost=3.84..3.87 rows=1 width=40) |
| -> Group (cost=3.84..3.86 rows=1 width=36) |
| Group Key: r_4.id, (CASE WHEN ((rvr_4.status = 0) AND (r_4.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr_4.status = 0) AND (r_4.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Sort (cost=3.84..3.85 rows=1 width=36) |
| Sort Key: r_4.id, (CASE WHEN ((rvr_4.status = 0) AND (r_4.next_verify_user = 1001)) THEN 1 ELSE 0 END), (CASE WHEN ((crvr_4.status = 0) AND (r_4.next_cancel_verify_user = 1001)) THEN 1 ELSE 0 END) |
| -> Nested Loop Left Join (cost=0.00..3.83 rows=1 width=36) |
| Join Filter: (crvr_4.punch_travel_id = r_4.id) |
| -> Nested Loop (cost=0.00..2.80 rows=1 width=40) |
| Join Filter: (r_4.id = rvr_4.punch_travel_id) |
| -> Seq Scan on tbl_punch_travel_verify_rels rvr_4 (cost=0.00..1.39 rows=1 width=8) |
| Filter: (user_id = 1001) |
| -> Seq Scan on tbl_punch_travels r_4 (cost=0.00..1.39 rows=2 width=36) |
| Filter: (status = ANY ('{1,5}'::integer[])) |
| -> Seq Scan on tbl_punch_travel_cancel_verify_rels crvr_4 (cost=0.00..1.01 rows=1 width=8) |