Sort (cost=5.58..5.59 rows=1 width=26) |
Sort Key: r.id |
-> Merge Join (cost=2.68..5.57 rows=1 width=26) |
Merge Cond: (u.id = r.user_id) |
-> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..34.61 rows=24 width=4) |
Filter: (user_status = '1'::type_global_user_status) |
-> Sort (cost=2.54..2.54 rows=1 width=26) |
Sort Key: r.user_id |
-> Seq Scan on tbl_punch_leave_verify_rels r (cost=0.00..2.53 rows=1 width=26) |
Filter: (punch_leave_id = 107) |