QUERY PLAN
Sort (cost=26.33..26.35 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=8.10..26.23 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=8.01..8.01 rows=7 width=12)
-> Seq Scan on tbl_task_group_head_of_relationships c (cost=0.00..8.01 rows=7 width=12)
Filter: (task_group_id = ANY ('{192,196,198,141,178}'::integer[]))