QUERY PLAN
Sort (cost=180.59..180.71 rows=46 width=265)
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=171.56..179.32 rows=46 width=265)
Hash Cond: (tbl_users.id = tbl_projects.creator)
-> Seq Scan on tbl_users (cost=0.00..7.39 rows=139 width=265)
-> Hash (cost=170.98..170.98 rows=46 width=4)
-> HashAggregate (cost=170.06..170.52 rows=46 width=4)
Group Key: tbl_projects.creator
-> Seq Scan on tbl_projects (cost=0.00..163.05 rows=2805 width=4)