QUERY PLAN
Group (cost=25.09..27.76 rows=97 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=25.09..25.33 rows=97 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=16.72..21.89 rows=97 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=16.58..16.82 rows=97 width=4)
Sort Key: rvr.user_id
-> Seq Scan on tbl_punch_leave_verify_rels rvr (cost=0.00..13.38 rows=97 width=4)
Filter: (punch_leave_id = ANY ('{15,33,26,3,4,27,5,19,7,18,8,48,9,28,10,36,11,20,35,13,21,29,12,14,37,22,30,23,24,31,25,54,46,32,38,34,44,39,40,49,41,52,42,47,50,56,53,51,55,57,58,60,59,61,62,63,64,77,65,96,66,89,67,68,80,69,90,70,81,71,72,82,73,97,83,91,84,74,76,75,85,98,92,86,93,87,99,88,94,100,95,101}'::integer[]))