| Sort (cost=196.30..196.42 rows=49 width=267) |
| 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=187.09..194.92 rows=49 width=267) |
| Hash Cond: (tbl_users.id = tbl_projects.creator) |
| -> Seq Scan on tbl_users (cost=0.00..7.44 rows=144 width=267) |
| -> Hash (cost=186.48..186.48 rows=49 width=4) |
| -> HashAggregate (cost=185.50..185.99 rows=49 width=4) |
| Group Key: tbl_projects.creator |
| -> Seq Scan on tbl_projects (cost=0.00..177.60 rows=3160 width=4) |