QUERY PLAN
Group (cost=9.30..9.33 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=9.30..9.30 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
-> Nested Loop Left Join (cost=0.14..9.29 rows=1 width=44)
-> Seq Scan on tbl_punch_overtime_verify_rels rvr (cost=0.00..1.01 rows=1 width=4)
Filter: (punch_overtime_id = ANY ('{6,10,12,11}'::integer[]))
-> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..8.16 rows=1 width=44)
Index Cond: (rvr.user_id = id)