| Limit (cost=18.24..50.78 rows=20 width=54) |
| -> Hash Left Join (cost=18.24..138.63 rows=74 width=54) |
| Hash Cond: (c.sales_rep = u.id) |
| -> Seq Scan on tbl_clients c (cost=0.00..120.19 rows=74 width=49) |
| Filter: ((NOT deleted) AND (sales_rep IS NOT NULL) AND (((name)::text ~~* '%xx%'::text) OR (pinyin_shortcut ~~* '%xx%'::text))) |
| -> Hash (cost=16.44..16.44 rows=144 width=13) |
| -> Seq Scan on tbl_users u (cost=0.00..16.44 rows=144 width=13) |