QUERY PLAN
Group (cost=80.78..86.53 rows=209 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=80.78..81.31 rows=209 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=9.13..72.73 rows=209 width=44)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_punch_repair_verify_rels rvr (cost=0.00..63.03 rows=209 width=4)
Filter: (punch_repair_id = ANY ('{25,11,26,14,16,3,27,15,5,18,6,42,7,4,28,20,29,21,10,30,22,13,12,53,23,40,46,24,39,38,56,33,41,35,34,57,37,45,58,44,49,36,48,52,43,55,51,54,47,50,59,60,61,62,63,64,65,99,94,93,98,92,80,91,79,90,78,89,77,104,76,88,75,87,86,74,85,113,84,73,83,82,72,81,71,114,70,69,68,67,115,66,97,103,96,102,116,108,101,107,95,112,106,111,100,110,105,109,117,118,119,120,121,122,123,124,125,128,152,127,126,129,151,150,149,162,148,146,161,145,140,160,144,166,159,172,158,167,139,157,138,143,147,156,137,136,142,135,170,134,141,133,132,168,131,130,155,154,183,153,164,169,171,173,178,174,187,184,186,188,189,190,191,193,194,221,196,210,197,211,198,222,212,199,200,223,215,214,207,213,206,205,224,204,203,216,202,208,225,209,217,218,219,220,228,229,234,232,235}'::integer[]))
-> Hash (cost=7.39..7.39 rows=139 width=44)
-> Seq Scan on tbl_users u (cost=0.00..7.39 rows=139 width=44)