QUERY PLAN
Group (cost=93.75..100.26 rows=237 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.75..94.34 rows=237 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.17..84.40 rows=237 width=44)
Hash Cond: (rvr.user_id = u.id)
-> Seq Scan on tbl_punch_repair_verify_rels rvr (cost=0.00..74.58 rows=237 width=4)
Filter: (punch_repair_id = ANY ('{25,11,26,14,16,3,27,15,5,17,18,6,42,19,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,177,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,163,176,164,169,171,173,179,178,174,181,175,187,180,184,185,186,188,189,190,191,192,193,194,236,221,196,210,195,197,230,211,198,222,212,199,201,241,200,223,215,214,231,207,213,206,205,224,204,203,216,202,208,237,225,209,217,232,218,226,219,220,227,233,228,238,229,234,242,235,239,243,240,244,246}'::integer[]))
-> Hash (cost=7.41..7.41 rows=141 width=44)
-> Seq Scan on tbl_users u (cost=0.00..7.41 rows=141 width=44)