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) |