| Limit (cost=9.13..123.40 rows=10 width=54) |
| -> Hash Left Join (cost=9.13..123.40 rows=10 width=54) |
| Hash Cond: (c.sales_rep = u.id) |
| -> Seq Scan on tbl_clients c (cost=0.00..114.25 rows=10 width=49) |
| Filter: ((NOT deleted) AND (sales_rep IS NOT NULL) AND (((name)::text ~~* '%测试%'::text) OR (pinyin_shortcut ~~* '%测试%'::text))) |
| -> Hash (cost=7.39..7.39 rows=139 width=13) |
| -> Seq Scan on tbl_users u (cost=0.00..7.39 rows=139 width=13) |