| Sort (cost=24.76..24.81 rows=20 width=3844) |
| 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=21.82..24.32 rows=20 width=3844) |
| Hash Cond: (tbl_projects.creator = tbl_users.id) |
| -> HashAggregate (cost=11.38..12.47 rows=110 width=4) |
| Group Key: tbl_projects.creator |
| -> Seq Scan on tbl_projects (cost=0.00..11.10 rows=110 width=4) |
| -> Hash (cost=10.20..10.20 rows=20 width=3844) |
| -> Seq Scan on tbl_users (cost=0.00..10.20 rows=20 width=3844) |