QUERY PLAN
Group (cost=8.97..9.00 rows=1 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=8.97..8.98 rows=1 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 Right Join (cost=1.04..8.96 rows=1 width=44)
Hash Cond: (u.id = rvr.user_id)
-> Seq Scan on tbl_users u (cost=0.00..7.39 rows=139 width=44)
-> Hash (cost=1.03..1.03 rows=1 width=4)
-> Seq Scan on tbl_punch_overtime_verify_rels rvr (cost=0.00..1.03 rows=1 width=4)
Filter: (punch_overtime_id = ANY ('{6,9,10,15,16,17,18,20,21,22,23,24,25}'::integer[]))