| Nested Loop Left Join (cost=4.78..81.69 rows=16 width=58) |
| Join Filter: (c.sales_rep = u.id) |
| -> Bitmap Heap Scan on tbl_clients c (cost=4.63..73.28 rows=16 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)) |
| -> Materialize (cost=0.14..8.17 rows=1 width=13) |
| -> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..8.16 rows=1 width=13) |
| Index Cond: (id = 1001) |