| Aggregate (cost=17.88..17.89 rows=1 width=8) |
| -> Sort (cost=17.34..17.43 rows=36 width=3485) |
| Sort Key: d."order", dp.created_at, u.pinyin1 NULLS FIRST, u.namecut1 NULLS FIRST, u.pinyin2 NULLS FIRST, u.namecut2 NULLS FIRST, u.pinyin3 NULLS FIRST, u.namecut3 NULLS FIRST, u.pinyin4 NULLS FIRST, u.namecut4 NULLS FIRST |
| -> HashAggregate (cost=16.05..16.41 rows=36 width=3485) |
| Group Key: u.id, d."order", dp.created_at |
| -> Hash Left Join (cost=10.77..15.78 rows=36 width=45) |
| Hash Cond: (u.department_position_id = dp.id) |
| -> Hash Left Join (cost=9.30..14.19 rows=36 width=41) |
| Hash Cond: (u.department_id = d.id) |
| -> Hash Right Join (cost=8.10..12.85 rows=36 width=43) |
| Hash Cond: (aa.user_id = u.id) |
| -> Seq Scan on tbl_auth_assignments aa (cost=0.00..4.16 rows=216 width=15) |
| -> Hash (cost=7.80..7.80 rows=24 width=43) |
| -> Seq Scan on tbl_users u (cost=0.00..7.80 rows=24 width=43) |
| Filter: (user_status = ANY ('{1,2}'::type_global_user_status[])) |
| -> Hash (cost=1.09..1.09 rows=9 width=6) |
| -> Seq Scan on tbl_departments d (cost=0.00..1.09 rows=9 width=6) |
| -> Hash (cost=1.21..1.21 rows=21 width=12) |
| -> Seq Scan on tbl_department_positions dp (cost=0.00..1.21 rows=21 width=12) |