| Sort (cost=18.42..18.44 rows=9 width=156) |
| Sort Key: tbl_departments."order" |
| -> Hash Join (cost=17.07..18.28 rows=9 width=156) |
| Hash Cond: (tbl_departments.id = tbl_users.department_id) |
| -> Seq Scan on tbl_departments (cost=0.00..1.09 rows=9 width=152) |
| -> Hash (cost=16.95..16.95 rows=9 width=4) |
| -> HashAggregate (cost=16.86..16.95 rows=9 width=4) |
| Group Key: tbl_users.department_id |
| -> Seq Scan on tbl_users (cost=0.00..16.80 rows=25 width=4) |
| Filter: (user_status = '1'::type_global_user_status) |