| Group (cost=11.32..11.87 rows=20 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=11.32..11.37 rows=20 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=2.75..10.89 rows=20 width=44) |
| Hash Cond: (u.id = rvr.user_id) |
| -> Seq Scan on tbl_users u (cost=0.00..7.41 rows=141 width=44) |
| -> Hash (cost=2.50..2.50 rows=20 width=4) |
| -> Seq Scan on tbl_punch_travel_verify_rels rvr (cost=0.00..2.50 rows=20 width=4) |
| Filter: (punch_travel_id = ANY ('{18,17,16,6,28,5,4,7,21,9,29,8,20,10,19,11,13,22,12,30,14,34,15,23,24,25,31,27,32,26,37,38}'::integer[])) |