| Limit (cost=0.14..7.36 rows=20 width=54) |
| -> Nested Loop Left Join (cost=0.14..341.82 rows=947 width=54) |
| -> Seq Scan on tbl_clients c (cost=0.00..120.19 rows=947 width=49) |
| Filter: ((NOT deleted) AND (sales_rep IS NOT NULL) AND (((name)::text ~~* '%x%'::text) OR (pinyin_shortcut ~~* '%x%'::text))) |
| -> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..0.23 rows=1 width=13) |
| Index Cond: (c.sales_rep = id) |