| Sort (cost=306.19..306.21 rows=5 width=48) |
| Sort Key: tbl_users.pinyin1 NULLS FIRST, tbl_users.namecut1 NULLS FIRST, tbl_users.pinyin2 NULLS FIRST, tbl_users.namecut2 NULLS FIRST, tbl_users.pinyin3 NULLS FIRST, tbl_users.namecut3 NULLS FIRST, tbl_users.pinyin4 NULLS FIRST, tbl_users.namecut4 NULLS FIRST |
| -> Hash Join (cost=289.27..306.14 rows=5 width=48) |
| Hash Cond: (tbl_users.id = tbl_cases.created_by) |
| -> Seq Scan on tbl_users (cost=0.00..16.80 rows=25 width=44) |
| Filter: (user_status = ANY ('{1,2}'::type_global_user_status[])) |
| -> Hash (cost=288.94..288.94 rows=26 width=4) |
| -> HashAggregate (cost=288.43..288.69 rows=26 width=4) |
| Group Key: tbl_cases.created_by |
| -> Seq Scan on tbl_cases (cost=0.00..267.14 rows=8514 width=4) |