QUERY PLAN
Sort (cost=27.35..27.37 rows=7 width=43)
Sort Key: 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
-> Hash Right Join (cost=9.13..27.26 rows=7 width=43)
Hash Cond: (u.id = c.user_id)
-> Seq Scan on tbl_users u (cost=0.00..16.44 rows=144 width=35)
-> Hash (cost=9.04..9.04 rows=7 width=12)
-> Seq Scan on tbl_task_group_user_relationships c (cost=0.00..9.04 rows=7 width=12)
Filter: (task_group_id = 106)