QUERY PLAN
Group (cost=93.96..97.95 rows=145 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=93.96..94.33 rows=145 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 Left Join (cost=18.24..88.76 rows=145 width=44)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_punch_away_verify_rels rvr (cost=0.00..70.13 rows=145 width=4)
Filter: (punch_away_id = ANY ('{11,19,12,13,20,14,6,29,7,25,15,21,9,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,52,45,53,46,63,47,59,54,48,49,55,50,73,51,60,56,67,64,57,61,62,70,65,68,66,72,69,71,74,75,77,76,78,79,80,81,90,82,105,101,83,91,84,97,85,92,86,102,93,88,87,98,89,95,99,94,96,100,108,107,104,110,103,106,109,114,112,111,113,115,116,136,129,122,130,123,124,137,131,125,126,132,127,142,128,138,133,152,134,139,147,140,144,141,149,143,146,145,151,148,150,155,153,154,156,157,158,159,169,160,161,171,162,177,163,172,164,187,165,170,166,174,167,178,168,175,185,179,176,181,180,173,189,193,183,191,186,188,184,190,182,192,194,195,196,197,198,219,214,208,200,201,215,209,202,203,206,199,204,211,205,216,207,212,210,228,223,213,220,217,218,226,224,221,222,229,225,227,230,231,232,233,234,235,236,237,238,239,240,241,243,244}'::integer[]))
-> Hash (cost=16.44..16.44 rows=144 width=44)
-> Seq Scan on tbl_users u (cost=0.00..16.44 rows=144 width=44)