QUERY PLAN
Group (cost=11.29..11.98 rows=25 width=52)
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=11.29..11.35 rows=25 width=44)
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 Right Join (cost=2.55..10.71 rows=25 width=44)
Hash Cond: (u.id = rvr.user_id)
-> Seq Scan on tbl_users u (cost=0.00..7.39 rows=139 width=44)
-> Hash (cost=2.24..2.24 rows=25 width=4)
-> Seq Scan on tbl_punch_travel_verify_rels rvr (cost=0.00..2.24 rows=25 width=4)
Filter: (punch_travel_id = ANY ('{18,17,16,6,28,5,4,21,9,29,8,20,13,22,12,30,14,15,23,24,31,27,32,26,34}'::integer[]))