| Nested Loop Left Join (cost=4.77..81.45 rows=1 width=58) |
| Join Filter: (c.sales_rep = u.id) |
| -> Bitmap Heap Scan on tbl_clients c (cost=4.63..73.28 rows=1 width=49) |
| Recheck Cond: ((sales_rep IS NOT NULL) AND (sales_rep = 1001)) |
| Filter: ((NOT deleted) AND (((name)::text ~~* '%北京过年%'::text) OR (pinyin_shortcut ~~* '%北京过年%'::text))) |
| -> Bitmap Index Scan on tbl_clients_sales_rep_idx (cost=0.00..4.63 rows=35 width=0) |
| Index Cond: ((sales_rep IS NOT NULL) AND (sales_rep = 1001)) |
| -> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..8.16 rows=1 width=13) |
| Index Cond: (id = 1001) |