| Sort (cost=374.88..374.90 rows=9 width=156) |
| Sort Key: tbl_departments."order" |
| -> Nested Loop Semi Join (cost=362.97..374.73 rows=9 width=156) |
| Join Filter: (tbl_departments.id = tbl_users.department_id) |
| -> Seq Scan on tbl_departments (cost=0.00..1.09 rows=9 width=152) |
| -> Materialize (cost=362.97..371.50 rows=82 width=4) |
| -> Seq Scan on tbl_users (cost=362.97..371.08 rows=82 width=4) |
| Filter: ((user_status = '1'::type_global_user_status) OR (hashed SubPlan 1)) |
| SubPlan 1 |
| -> Seq Scan on tbl_reimbursement_verify_rels (cost=0.00..362.96 rows=3 width=4) |
| Filter: (reimbursement_id = 7912) |