QUERY PLAN
Group (cost=30.83..33.85 rows=110 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=30.83..31.10 rows=110 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
-> Merge Right Join (cost=22.72..27.10 rows=110 width=44)
Merge Cond: (u.id = rvr.user_id)
-> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..34.22 rows=139 width=44)
-> Sort (cost=22.58..22.85 rows=110 width=4)
Sort Key: rvr.user_id
-> Seq Scan on tbl_punch_away_verify_rels rvr (cost=0.00..18.85 rows=110 width=4)
Filter: (punch_away_id = ANY ('{11,19,12,13,20,14,29,25,15,21,16,10,35,22,17,18,28,26,23,24,27,32,34,30,33,31,38,37,36,40,39,41,42,58,43,45,53,46,63,47,59,54,48,49,55,50,73,51,60,56,67,64,70,65,68,66,72,69,71,74,75,77,76,78,79,80,81,90,105,101,83,91,84,97,85,92,86,93,88,87,98,89,95,99,94,96,100,108,107,104,110,103,106,109,114,112,111,113,115,116,129,122,130,123,124,131,125,126,132,128}'::integer[]))