QUERY PLAN
Group (cost=32.77..33.04 rows=10 width=686)
Group Key: u.pinyin1, u.namecut1, u.pinyin2, u.namecut2, u.pinyin3, u.namecut3, u.pinyin4, u.namecut4, rvr.user_id, u.name
-> Sort (cost=32.77..32.79 rows=10 width=678)
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, rvr.user_id, u.name
-> Hash Left Join (cost=10.45..32.60 rows=10 width=678)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_approve_verify_rels rvr (cost=0.00..22.12 rows=10 width=4)
Filter: (approve_id = ANY ('{1,2}'::integer[]))
-> Hash (cost=10.20..10.20 rows=20 width=678)
-> Seq Scan on tbl_users u (cost=0.00..10.20 rows=20 width=678)