| Sort (cost=38.44..38.50 rows=25 width=52) |
| Sort Key: tbl_users.pinyin1 NULLS FIRST, tbl_users.namecut1 NULLS FIRST, tbl_users.pinyin2 NULLS FIRST, tbl_users.namecut2 NULLS FIRST, tbl_users.pinyin3 NULLS FIRST, tbl_users.namecut3 NULLS FIRST, tbl_users.pinyin4 NULLS FIRST, tbl_users.namecut4 NULLS FIRST |
| -> Hash Join (cost=33.33..37.86 rows=25 width=52) |
| Hash Cond: (p.created_by = tbl_users.id) |
| -> HashAggregate (cost=25.25..27.25 rows=200 width=4) |
| Group Key: p.created_by |
| -> HashAggregate (cost=22.75..24.75 rows=200 width=4) |
| Group Key: p.created_by |
| -> Seq Scan on tbl_erp_bank_change_logs p (cost=0.00..20.20 rows=1020 width=4) |
| -> Hash (cost=7.76..7.76 rows=25 width=48) |
| -> Seq Scan on tbl_users (cost=0.00..7.76 rows=25 width=48) |
| Filter: (user_status = '1'::type_global_user_status) |