QUERY PLAN
Group (cost=52.98..55.89 rows=106 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=52.98..53.24 rows=106 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=40.99..49.41 rows=106 width=44)
Merge Cond: (u.id = rvr.user_id)
-> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..70.08 rows=144 width=44)
-> Sort (cost=40.84..41.11 rows=106 width=4)
Sort Key: rvr.user_id
-> Seq Scan on tbl_punch_leave_verify_rels rvr (cost=0.00..37.28 rows=106 width=4)
Filter: (punch_leave_id = ANY ('{176,172,175,15,33,26,3,4,27,5,19,7,18,8,48,9,43,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,45,50,56,53,51,55,57,58,60,59,61,62,124,125,126,63,64,77,65,96,66,89,67,68,80,69,107,90,70,81,71,72,82,73,97,83,103,91,84,74,76,75,85,98,92,86,93,87,114,99,88,104,94,100,95,108,105,101,102,111,106,109,113,110,112,116,118,115,117,119,120,121,122,123,160,127,143,128,140,129,154,130,144,131,132,145,133,155,134,146,135,161,136,137,156,148,138,139,162,149,141,157,147,142,158,150,151,163,152,153,159,164,165,166}'::integer[]))